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.12 -r1.13
--- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	30 Sep 2003 12:10:01 -0000	1.12
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	7 Nov 2003 19:51:43 -0000	1.13
@@ -614,14 +614,14 @@
     from 
       cr_items
     where
-      name = name
+      name = rename.name
     and 
       parent_id = (select 
 		     parent_id
 		   from
 		     cr_items
 		   where
-		     item_id = item_id);
+		     item_id = rename.item_id);
 
   exists_id integer;
 begin
@@ -632,13 +632,13 @@
   if exists_cur%NOTFOUND then
     close exists_cur;
     update cr_items
-      set name = name
-      where item_id = item_id;
+      set name = rename.name
+      where item_id = rename.item_id;
   else
     close exists_cur;
-    if exists_id <> item_id then
+    if exists_id <> rename.item_id then
       raise_application_error(-20000, 
-        'An item with the name ' || name || 
+        'An item with the name ' || rename.name || 
         ' already exists in this directory.');
     end if;
   end if;