oracle8.1.6
select title
from cr_revisions, cr_items
where cr_items.item_id = :file_id
and revision_id=live_revision
begin
file_storage.rename_file (
file_id => :file_id,
title => :title
);
end;
select count(*)
from cr_items
where name = :title
and parent_id = content_item.get_parent_folder(:file_id)