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.23 -r1.24
--- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	20 Apr 2004 21:12:35 -0000	1.23
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	17 May 2004 15:14:44 -0000	1.24
@@ -629,14 +629,14 @@
     from 
       cr_items
     where
-      cr_items.name = name
+      cr_items.name = content_item.rename.name
     and 
       parent_id = (select 
 		     parent_id
 		   from
 		     cr_items
 		   where
-		     cr_items.item_id = item_id);
+		     cr_items.item_id = content_item.rename.item_id);
 
   exists_id integer;
 begin
@@ -647,12 +647,12 @@
   if exists_cur%NOTFOUND then
     close exists_cur;
     update cr_items
-	set cr_items.name = rename.name
-       	where cr_items.item_id = rename.item_id;
+	set cr_items.name = content_item.rename.name
+       	where cr_items.item_id = content_item.rename.item_id;
 
     update acs_objects
-      set title = rename.name
-      where object_id = rename.item_id;
+      set title = content_item.rename.name
+      where object_id = content_item.rename.item_id;
   else
     close exists_cur;
     if exists_id <> item_id then