Index: openacs-4/packages/acs-content-repository/sql/oracle/content-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-test.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-content-repository/sql/oracle/content-test.sql 24 Mar 2001 22:00:48 -0000 1.1 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-test.sql 25 Aug 2001 14:22:32 -0000 1.2 @@ -1,4 +1,4 @@ -set serveroutput on +set serveroutput on size 1000000 format wrapped declare folder_id cr_folders.folder_id%TYPE; @@ -24,8 +24,8 @@ -- create folders and an item -folder_id := content_folder.new('grandpa', 'Grandpa', NULL, -1); -folder_b_id := content_folder.new('grandma', 'Grandma', NULL, -1); +folder_id := content_folder.new('grandpa', 'Grandpa', NULL, -100); +folder_b_id := content_folder.new('grandma', 'Grandma', NULL, -100); sub_folder_id := content_folder.new('pa', 'Pa', NULL, folder_id); sub_sub_folder_id := content_folder.new('me', 'Me', NULL, sub_folder_id); item_id := content_item.new('puppy', sub_sub_folder_id); @@ -210,7 +210,7 @@ --dbms_output.put_line('Path for ' || item_id || ' is ' || --content_item.get_path(item_id)); --dbms_output.put_line('Moving grandpa to pa - this should''nt work'); -content_folder.move(folder_id, sub_folder_id); +-- content_folder.move(folder_id, sub_folder_id); --dbms_output.put_line('Path for ' || item_id || ' is ' || -- content_item.get_path(item_id)); --dbms_output.put_line('Renaming puppy to kitty...');