oracle8.1.6 declare copy_id integer; begin copy_id := content_item.copy2( :template_id, :folder_id, :creation_user, :creation_ip ); insert into cr_templates (template_id) values (copy_id); end; select content_item.get_path(:folder_id) from dual