Index: openacs-4/packages/new-portal/sql/oracle/api-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/api-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/new-portal/sql/oracle/api-create.sql 28 Sep 2001 01:46:52 -0000 1.1 +++ openacs-4/packages/new-portal/sql/oracle/api-create.sql 28 Sep 2001 15:47:15 -0000 1.2 @@ -51,8 +51,8 @@ as function new ( portal_id in portals.portal_id%TYPE default null, - layout_id in portals.layout_id%TYPE default null, name in portals.name%TYPE default null, + layout_id in portals.layout_id%TYPE default null, owner_id in persons.person_id%TYPE default 0, object_type in acs_object_types.object_type%TYPE default 'portal', creation_date in acs_objects.creation_date%TYPE @@ -74,15 +74,8 @@ context_id => context_id ); - insert into portals ( - portal_id, - layout_id, - name, - owner_id - ) values ( - v_portal_id, - layout_id, - name, + insert into portals (portal_id, layout_id, name, owner_id) + values (v_portal_id, layout_id, name, decode(owner_id, 0, NULL, owner_id) );