oracle8.1.6 begin content_item.delete(:revision_id) end; select title from cr_revisions r, cr_items i where i.parent_id = etp.get_folder_id(:package_id) and i.name = :name and r.item_id = i.item_id and r.revision_id = i.live_revision select item_id from cr_items where parent_id = etp.get_folder_id(:package_id) and name = :name