[Zope-Checkins] CVS: Products/DCOracle2/test - procdef.sql:1.14

[Matthew T. Kromer]

Update of /cvs-repository/Products/DCOracle2/test
In directory cvs.zope.org:/tmp/cvs-serv9189/test

Modified Files:
	procdef.sql 
Log Message:
Add BLOB/CLOB handing to stored procs, re collector issue #40.  Instead of
allocating a BindingArray for the OUT variables which are LOBs, a LobLocator
is allocated instead.  This doesn't support array output of LOBs, however.


=== Products/DCOracle2/test/procdef.sql 1.13 => 1.14 ===
 show errors;
 
+create or replace function FINDPHOTO (
+		PHOTONAME in varchar2
+	) return BLOB
+	as
+	PHOTOBLOB BLOB;
+	begin
+		select PHOTO into PHOTOBLOB from BLOBTEST
+			where NAME = PHOTONAME;
+		return PHOTOBLOB;
+	end FINDPHOTO;
+/
+show errors;
+
 create or replace package EMP_ACTIONS as
 	type ref_cursor is ref cursor;
 	type string_tab is table of varchar2(20) index by binary_integer;