oracle 8.1.6 begin :1 := file_storage.copy_file( :object_id, :folder_id, :user_id, :peer_addr, :name, :title); end; begin :1 = content_folder.copy ( :object_id, :folder_id, :user_id, :peer_addr, :name, :title); end; select cf.folder_id, ci1.parent_id, cf.label, ci1.level_num from cr_folders cf, (select item_id, level as level_num from cr_items where cr_items.item_id not in ($object_id_list) connect by (prior item_id=parent_id and parent_id not in ($object_id_list)) start with cr_items.item_id = :root_folder_id ) ci1 where ci1.item_id=cf.folder_id and exists (select 1 from acs_object_party_privilege_map m where m.object_id = cf.folder_id and m.party_id = :user_id and m.privilege = 'write') order by ci1.level_num, cf.label