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.8 -r1.8.2.1
--- openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql	4 Mar 2004 14:52:35 -0000	1.8
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql	16 Mar 2004 18:33:27 -0000	1.8.2.1
@@ -166,15 +166,15 @@
   if label is not null and description is not null then 
 
     update cr_folders
-      set label = rename.label,
-      description = rename.description
-      where folder_id = rename.folder_id;
+       set cr_folders.label = label,
+       cr_folders.description = description
+       where cr_folders.folder_id = folder_id;
 
   elsif label is not null and description is null then 
 
     update cr_folders
-      set label = rename.label
-      where folder_id = rename.folder_id;
+       set cr_folders.label = label
+       where cr_folders.folder_id = folder_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.20 -r1.20.2.1
--- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	4 Mar 2004 14:52:35 -0000	1.20
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	16 Mar 2004 18:33:27 -0000	1.20.2.1
@@ -614,14 +614,14 @@
     from 
       cr_items
     where
-      name = rename.name
+      cr_items.name = name
     and 
       parent_id = (select 
 		     parent_id
 		   from
 		     cr_items
 		   where
-		     item_id = rename.item_id);
+		     cr_items.item_id = item_id);
 
   exists_id integer;
 begin
@@ -632,13 +632,13 @@
   if exists_cur%NOTFOUND then
     close exists_cur;
     update cr_items
-      set name = rename.name
-      where item_id = rename.item_id;
+	set cr_items.name = name
+       	where cr_items.item_id = item_id;
   else
     close exists_cur;
-    if exists_id <> rename.item_id then
+    if exists_id <> item_id then
       raise_application_error(-20000, 
-        'An item with the name ' || rename.name || 
+        'An item with the name ' || name || 
         ' already exists in this directory.');
     end if;
   end if;