Index: openacs-4/packages/organizations/sql/oracle/organizations-plsql-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/oracle/organizations-plsql-create.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/organizations/sql/oracle/organizations-plsql-create.sql	30 Sep 2003 12:10:08 -0000	1.2
+++ openacs-4/packages/organizations/sql/oracle/organizations-plsql-create.sql	11 Dec 2003 21:40:09 -0000	1.3
@@ -42,6 +42,10 @@
 /
 show errors
 
+
+-- behavior is different between oracle and postgres. Postgres
+-- version adds in the first organization_type to the organization_type_map
+-- table, to specify which type this organization is.
 create or replace package body organization
 as
     function new (
@@ -102,9 +106,12 @@
   ) 
   is
   begin
+
+   -- these delete statements should not be necessary
    delete from acs_permissions 
      where object_id = organization.del.p_organization_id; 
 
+   -- need to remove items from organization_type_map, like postgres
    delete from organizations 
      where organization_id = organization.del.p_organization_id;
 
@@ -115,3 +122,5 @@
 end organization;
 /
 show errors
+
+-- name function is missing in Oracle version!! Need to port from Postgres