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.17 -r1.18 --- openacs-4/packages/new-portal/sql/oracle/api-create.sql 14 Nov 2001 22:02:40 -0000 1.17 +++ openacs-4/packages/new-portal/sql/oracle/api-create.sql 15 Nov 2001 21:17:14 -0000 1.18 @@ -252,15 +252,9 @@ create or replace package portal_datasource as function new ( - datasource_id in portal_datasources.datasource_id%TYPE default null, - secure_p in portal_datasources.secure_p%TYPE default null, - configurable_p in portal_datasources.configurable_p%TYPE default null, name in portal_datasources.name%TYPE default null, - link in portal_datasources.link%TYPE default null, description in portal_datasources.description%TYPE default null, - content in portal_datasources.content%TYPE default null, - edit_content in portal_datasources.edit_content%TYPE default null, - config_path in portal_datasources.config_path%TYPE default null, + configurable_p in portal_datasources.configurable_p%TYPE default null, object_type in acs_object_types.object_type%TYPE default 'portal_datasource', creation_date in acs_objects.creation_date%TYPE default sysdate, @@ -290,27 +284,17 @@ create or replace package body portal_datasource as function new ( - datasource_id in portal_datasources.datasource_id%TYPE default null, - secure_p in portal_datasources.secure_p%TYPE default null, - configurable_p in portal_datasources.configurable_p%TYPE default null, name in portal_datasources.name%TYPE default null, - link in portal_datasources.link%TYPE default null, description in portal_datasources.description%TYPE default null, - content in portal_datasources.content%TYPE default null, - edit_content in portal_datasources.edit_content%TYPE default null, - config_path in portal_datasources.config_path%TYPE default null, + configurable_p in portal_datasources.configurable_p%TYPE default null, object_type in acs_object_types.object_type%TYPE default 'portal_datasource', - creation_date in acs_objects.creation_date%TYPE - default sysdate, - creation_user in acs_objects.creation_user%TYPE - default null, + creation_date in acs_objects.creation_date%TYPE default sysdate, + 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; --- v_content_loc portal_datasources.content%TYPE; --- v_config_path_loc portal_datasources.config_path%TYPE; begin v_datasource_id := acs_object.new ( object_id => datasource_id, @@ -321,37 +305,11 @@ context_id => context_id ); --- if content_varchar is not null --- then --- dbms_lob.createtemporary(v_content_loc, TRUE); --- dbms_lob.write(v_content_loc, length(new.content_varchar), 1, new.content_varchar); --- else --- v_content_loc := content; --- end if; --- - - insert into portal_datasources - (datasource_id, - name, - link, - description, - secure_p, - configurable_p, - content, - edit_content, - config_path) + (datssource_id, name, description, configurable_p) values - (v_datasource_id, - name, - link, - description, - secure_p, - configurable_p, - content, - edit_content, - config_path); + (v_datasource_id, name, description, configurable_p); return v_datasource_id; end new;