Index: openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.0d1-2.0b2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.0d1-2.0b2.sql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.0d1-2.0b2.sql	11 Dec 2003 21:39:59 -0000	1.2
+++ openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.0d1-2.0b2.sql	22 Jun 2005 17:45:42 -0000	1.2.2.1
@@ -4,8 +4,14 @@
 -- @cvs-id $Id$
 --
 
+-- AG: The fancy update...from syntax in the PG version is not compatible with
+-- either ora8 or ora9.
 
-update acs_objects
-set    context_id = package_id
-from   calendars
-where  calendar_id = object_id;
+begin
+  for cur in (select o.object_id, c.package_id from acs_objects o, calendars c where o.object_id = c.calendar_id) loop
+    update acs_objects set context_id = cur.package_id where object_id = cur.object_id;
+  end loop;
+end;
+/
+show errors;
+