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.18 -r1.19 --- openacs-4/packages/new-portal/sql/oracle/api-create.sql 15 Nov 2001 21:17:14 -0000 1.18 +++ openacs-4/packages/new-portal/sql/oracle/api-create.sql 16 Nov 2001 18:52:51 -0000 1.19 @@ -252,6 +252,7 @@ create or replace package portal_datasource as function new ( + datasource_id in portal_datasources.datasource_id%TYPE default null, name in portal_datasources.name%TYPE default null, description in portal_datasources.description%TYPE default null, configurable_p in portal_datasources.configurable_p%TYPE default null, @@ -284,6 +285,7 @@ create or replace package body portal_datasource as function new ( + datasource_id in portal_datasources.datasource_id%TYPE default null, name in portal_datasources.name%TYPE default null, description in portal_datasources.description%TYPE default null, configurable_p in portal_datasources.configurable_p%TYPE default null, @@ -292,6 +294,7 @@ creation_user in acs_objects.creation_user%TYPE default null, creation_ip in acs_objects.creation_ip%TYPE default null, context_id in acs_objects.context_id%TYPE default null + ) return portal_datasources.datasource_id%TYPE is v_datasource_id portal_datasources.datasource_id%TYPE; @@ -307,7 +310,7 @@ insert into portal_datasources - (datssource_id, name, description, configurable_p) + (datasource_id, name, description, configurable_p) values (v_datasource_id, name, description, configurable_p);