Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql 6 Jan 2004 15:54:28 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql 15 Jun 2004 15:48:16 -0000 1.1.2.1 @@ -96,9 +96,12 @@ -- sourced. We need to clean up the creates and once that is done -- we can turn this into a simple delete statement. -- - execute immediate 'delete from acs_permissions where object_id = :object_id or grantee_id = :object_id' + execute immediate 'delete from acs_permissions where object_id = :object_id' using in object_id; + execute immediate 'delete from acs_permissions where grantee_id = :object_id' + using in object_id; + for object_type in (select table_name, id_column from acs_object_types