oracle8.1.6 begin content_item.copy( item_id => :cp_item_id, target_folder_id => :folder_id, creation_user => :user_id, creation_ip => :ip ); end; select content_item.get_path( :folder_id ) from dual select content_item.get_title(item_id) title, content_item.get_path(item_id,:root_id) name, item_id, parent_id from cr_items where item_id in ([join $clip_items ","]) and -- only for those items which user has cm_examine cms_permission.permission_p(item_id, :user_id, 'cm_examine') = 't'