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.9 -r1.10
--- openacs-4/packages/new-portal/sql/oracle/api-create.sql	3 Oct 2001 18:24:24 -0000	1.9
+++ openacs-4/packages/new-portal/sql/oracle/api-create.sql	4 Oct 2001 19:31:10 -0000	1.10
@@ -309,7 +309,6 @@
 		name			in portal_datasources.name%TYPE default null,
 		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 
@@ -321,8 +320,8 @@
 	) 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;
+--		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,
@@ -333,20 +332,23 @@
 			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;
+--		  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, data_type,
 			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, config_path); 
+			mime_type, name, description, secure_p, configurable_p, content, config_path); 
 
 		return v_datasource_id;
 	end new;