oracle8.1.6 begin content_item.set_live_revision( revision_id => :revision_id ); end; select item_id, content_item.is_publishable( item_id ) as publish_p from cr_revisions where revision_id = :revision_id