oracle8.1.6 select item_id, mime_type, content_revision.is_live( revision_id ) is_live from cr_revisions where revision_id = :revision_id