[Zope-Checkins] CVS: Products/DCOracle2/test - scott.sql:1.2 procdef.sql:1.17

[Chris Withers]

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

Modified Files:
	scott.sql procdef.sql 
Log Message:
Tidyup of test preparation scripts.


=== Products/DCOracle2/test/scott.sql 1.1 => 1.2 ===
--- Products/DCOracle2/test/scott.sql:1.1	Wed Oct 29 06:43:37 2003
+++ Products/DCOracle2/test/scott.sql	Wed Oct 29 11:55:40 2003
@@ -69,7 +69,15 @@
 INSERT INTO SALGRADE VALUES (3,1401,2000);
 INSERT INTO SALGRADE VALUES (4,2001,3000);
 INSERT INTO SALGRADE VALUES (5,3001,9999);
+
+drop table TEST;
+create table TEST ( name varchar2(64), id number(9) );
+
+drop table BLOBTEST;
+create table BLOBTEST (name varchar2(32), id integer, photo blob) tablespace users;
+
 COMMIT;
 
 SET TERMOUT ON
+SHOW ERRORS;
 SET ECHO ON


=== Products/DCOracle2/test/procdef.sql 1.16 => 1.17 ===
--- Products/DCOracle2/test/procdef.sql:1.16	Wed Sep 24 11:51:03 2003
+++ Products/DCOracle2/test/procdef.sql	Wed Oct 29 11:55:40 2003
@@ -1,3 +1,6 @@
+SET TERMOUT OFF
+SET ECHO OFF
+
 -- SQL Stored procedure
 
 create or replace procedure FIND (
@@ -8,7 +11,9 @@
 		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,
@@ -18,7 +23,9 @@
 		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,
@@ -28,7 +35,9 @@
 		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 
@@ -36,7 +45,9 @@
 		return(-1);
 	end NEG1;
 /
+SET TERMOUT ON
 show errors;
+SET TERMOUT OFF
 
 create or replace function FINDPHOTO (
 		PHOTONAME in varchar2
@@ -49,7 +60,9 @@
 		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;
@@ -110,12 +123,13 @@
 		CSR out REF_CURSOR
 	);
 		
-
-
 end EMP_ACTIONS;
 /
 
+SET TERMOUT ON
 show errors;
+SET TERMOUT OFF
+
 create or replace package body EMP_ACTIONS as
 
 	function FIND (
@@ -233,5 +247,6 @@
 end EMP_ACTIONS;
 /
 
+SET TERMOUT ON
 show errors;
-
+SET ECHO ON