oracle8.1.6 begin content_item.copy( item_id => :cp_item_id, target_folder_id => :folder_id, creation_user => null, creation_ip => null ); 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 read acs_permission.permission_p(item_id, :user_id, 'read') = 't'