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.4 -r1.5
--- openacs-4/packages/new-portal/sql/oracle/api-create.sql	1 Oct 2001 18:15:34 -0000	1.4
+++ openacs-4/packages/new-portal/sql/oracle/api-create.sql	1 Oct 2001 20:26:47 -0000	1.5
@@ -273,6 +273,7 @@
 		description	in portal_datasources.description%TYPE default null,
 		content		in portal_datasources.content%TYPE default null,
 		content_varchar	varchar default null,
+		config_path	in portal_datasources.config_path%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,
@@ -300,9 +301,8 @@
 		name			in portal_datasources.name%TYPE default null,
 		description		in portal_datasources.description%TYPE default null,
 		content			in portal_datasources.content%TYPE default null,
-		config_varchar		varchar default null,
-		config_content		in portal_datasources.config_content%TYPE default null,
 		content_varchar		varchar default null,
+		config_path		in portal_datasources.config_path%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,
@@ -314,7 +314,7 @@
 	is
 		v_datasource_id		portal_datasources.datasource_id%TYPE;
 		v_content_loc		portal_datasources.content%TYPE;
-		v_config_content_loc	portal_datasources.config_content%TYPE;
+		v_config_path_loc	portal_datasources.config_path%TYPE;
 	begin
 		v_datasource_id := acs_object.new (
 			object_id	=> datasource_id,
@@ -333,20 +333,12 @@
 			v_content_loc := content;
 		end if;
 
-		if config_varchar is not null
-		then
-			dbms_lob.createtemporary(v_config_content_loc, TRUE);
-			dbms_lob.write(v_config_content_loc, length(new.config_content_varchar), 1, new.config_content_varchar);
-		else
-			v_config_content_loc := config_content;
-		end if;
-
 		insert into portal_datasources
 			(datasource_id, data_type,
-			mime_type, name, description, secure_p, configurable_p, content)
+			mime_type, name, description, secure_p, configurable_p, content, config_path)
 		values
 			(v_datasource_id, data_type,
-			mime_type, name, description, secure_p, configurable_p, v_content_loc); 
+			mime_type, name, description, secure_p, configurable_p, v_content_loc, config_path); 
 
 		return v_datasource_id;
 	end new;