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

[Chris Withers]

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

Modified Files:
	procdef.sql 
Log Message:
Don't hide useful error messages.


=== Products/DCOracle2/test/procdef.sql 1.17 => 1.18 ===
--- Products/DCOracle2/test/procdef.sql:1.17	Wed Oct 29 11:55:40 2003
+++ Products/DCOracle2/test/procdef.sql	Thu Oct 30 06:18:12 2003
@@ -1,4 +1,3 @@
-SET TERMOUT OFF
 SET ECHO OFF
 
 -- SQL Stored procedure
@@ -11,9 +10,7 @@
 		select ENAME into EMPNAME from EMP where EMPNO = EMPID;
 	end FIND;
 /
-SET TERMOUT ON
 show errors;
-SET TERMOUT OFF
 
 create or replace procedure TESTINSERT (
 		I_NAME in varchar2,
@@ -23,9 +20,7 @@
 		insert into TEST (NAME, ID) values (I_NAME, I_ID);
 	end TESTINSERT;
 /
-SET TERMOUT ON
 show errors;
-SET TERMOUT OFF
 
 create or replace procedure FINDDEF (
 		EMPID in integer default 7902,
@@ -35,9 +30,7 @@
 		select ENAME into EMPNAME from EMP where EMPNO = EMPID;
 	end FINDDEF;
 /
-SET TERMOUT ON
 show errors;
-SET TERMOUT OFF
 
 create or replace function NEG1 
 	return integer as 
@@ -45,9 +38,7 @@
 		return(-1);
 	end NEG1;
 /
-SET TERMOUT ON
 show errors;
-SET TERMOUT OFF
 
 create or replace function FINDPHOTO (
 		PHOTONAME in varchar2
@@ -60,9 +51,7 @@
 		return PHOTOBLOB;
 	end FINDPHOTO;
 /
-SET TERMOUT ON
 show errors;
-SET TERMOUT OFF
 
 create or replace package EMP_ACTIONS as
 	type ref_cursor is ref cursor;
@@ -126,9 +115,7 @@
 end EMP_ACTIONS;
 /
 
-SET TERMOUT ON
 show errors;
-SET TERMOUT OFF
 
 create or replace package body EMP_ACTIONS as
 
@@ -247,6 +234,7 @@
 end EMP_ACTIONS;
 /
 
-SET TERMOUT ON
+COMMIT;
+
 show errors;
 SET ECHO ON