oracle8.1.6 select count(*) from cr_revisions where item_id = :file_id and acs_permission.permission_p(revision_id,:user_id,'delete') = 'f' begin content_item.delete(:file_id); end; select title as file_name from cr_revisions where revision_id = content_item.get_live_revision(:file_id)