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)