Hi all,
this is my situation:
I have 2 compiled packages and one compiled procedure which uses the 2 packages. I want to start the procedure with sql*plus.
To do this, I wrote a script and start the script from sql*plus:
SQL> @start_proc.sql
The
start_proc.sql script looks like this:
SET SERVEROUTPUT ON
SET ECHO OFF
SET TERMOUT OFF
WHENEVER SQLERROR CONTINUE
SPOOL /home/scott/proc_out.txt
BEGIN
SCHEMA1.TEST_PR;
COMMIT;
END;
/
SPOOL OFF
The question is, where should i put the statement
WHENEVER SQLERROR CONTINUE ?
In the current position, the procedure does not start at all. If I remove the statement completely, then I get error on the first record and the procedure does not go on with the rest of the records...