oracle 8.1.6 select fs.object_id, fs.name, acs_permission.permission_p(fs.object_id, :user_id, 'write') as move_p from fs_objects fs where fs.object_id in ([template::util::tcl_to_sql_list $object_id]) order by move_p select content_item.move( :one_item, :folder_id ) select cf.folder_id, cf.label, ci1.level from cr_folders cf, (select item_id, level from cr_items connect by prior item_id=parent_id start with :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 order by ci1.level, cf.label