Index: openacs-4/packages/acs-content-repository/sql/oracle/content-extlink.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-extlink.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-content-repository/sql/oracle/content-extlink.sql	12 Mar 2004 18:48:46 -0000	1.9
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-extlink.sql	9 Apr 2004 14:00:11 -0000	1.10
@@ -25,7 +25,7 @@
   creation_user	in acs_objects.creation_user%TYPE
 			   default null,
   creation_ip	in acs_objects.creation_ip%TYPE default null,
-  package_id    in acs_objects.package_id%TYPE
+  package_id    in acs_objects.package_id%TYPE default null
 ) return cr_extlinks.extlink_id%TYPE is
 
   v_extlink_id		cr_extlinks.extlink_id%TYPE;
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql	12 Mar 2004 18:48:46 -0000	1.9
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql	9 Apr 2004 14:00:11 -0000	1.10
@@ -23,7 +23,7 @@
   creation_date	in acs_objects.creation_date%TYPE default sysdate,
   creation_user	in acs_objects.creation_user%TYPE default null,
   creation_ip	in acs_objects.creation_ip%TYPE default null,
-  package_id	in acs_objects.package_id%TYPE default null,
+  package_id	in acs_objects.package_id%TYPE default null
 ) return cr_folders.folder_id%TYPE is
   v_folder_id	cr_folders.folder_id%TYPE;
   v_context_id	acs_objects.context_id%TYPE;
@@ -47,7 +47,7 @@
 
     v_package_id := package_id;
 
-    if parent_id is not null and package_id is null then
+    if parent_id is not null and parent_id ^= 0 and package_id is null then
         v_package_id := acs_object.package_id(content_item.get_root_folder(parent_id));
     end if;
 
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql,v
diff -u -r1.21 -r1.22
--- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	12 Mar 2004 18:48:46 -0000	1.21
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	9 Apr 2004 14:00:11 -0000	1.22
@@ -111,7 +111,7 @@
     v_parent_id := parent_id;
   end if;
 
-  if package_id is null then
+  if package_id is null and parent_id ^= 0 then
     v_package_id := acs_object.package_id(content_item.get_root_folder(v_parent_id));
   else
     v_package_id := package_id;
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-symlink.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-symlink.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-content-repository/sql/oracle/content-symlink.sql	12 Mar 2004 18:48:46 -0000	1.8
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-symlink.sql	9 Apr 2004 14:00:11 -0000	1.9
@@ -22,7 +22,7 @@
   creation_date	in acs_objects.creation_date%TYPE default sysdate,
   creation_user	in acs_objects.creation_user%TYPE default null,
   creation_ip	in acs_objects.creation_ip%TYPE default null,
-  package_id    in acs_objects.package_id%TYPE
+  package_id    in acs_objects.package_id%TYPE default null
 ) return cr_symlinks.symlink_id%TYPE is
   v_symlink_id		cr_symlinks.symlink_id%TYPE;
   v_package_id		acs_objects.package_id%TYPE;
Index: openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql	12 Mar 2004 18:48:46 -0000	1.18
+++ openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql	9 Apr 2004 14:00:11 -0000	1.19
@@ -1035,7 +1035,7 @@
   creation_user	in acs_objects.creation_user%TYPE
 			   default null,
   creation_ip	in acs_objects.creation_ip%TYPE default null,
-  package_id    in acs_objects.package_id%TYPE
+  package_id    in acs_objects.package_id%TYPE default null
 ) return cr_symlinks.symlink_id%TYPE;
 
 
@@ -1135,7 +1135,7 @@
   creation_user	in acs_objects.creation_user%TYPE
 			   default null,
   creation_ip	in acs_objects.creation_ip%TYPE default null,
-  package_id    in acs_objects.package_id%TYPE
+  package_id    in acs_objects.package_id%TYPE default null
 ) return cr_extlinks.extlink_id%TYPE;