E ekinox Member Sep 12, 2003 #1 hi guys. i have several anonymous sql blocks in one file which is executes via sqlplus. I want to stop the execution of the whole file if an error occurs in one of the blocks. Please help.
hi guys. i have several anonymous sql blocks in one file which is executes via sqlplus. I want to stop the execution of the whole file if an error occurs in one of the blocks. Please help.
A aotte Member³ Sep 13, 2003 #1 Is this what you are looking for? WHENEVER SQLERROR EXIT SQL.SQLCODE; WHENEVER OSERROR EXIT FAILURE; ------------------ Hakuna Matata, Arnoud.
Is this what you are looking for? WHENEVER SQLERROR EXIT SQL.SQLCODE; WHENEVER OSERROR EXIT FAILURE; ------------------ Hakuna Matata, Arnoud.
E ekinox Member Sep 15, 2003 #1 Originally posted by aotte: Is this what you are looking for? WHENEVER SQLERROR EXIT SQL.SQLCODE; WHENEVER OSERROR EXIT FAILURE; Click to expand... Thanx for helping me man. Ekinox
Originally posted by aotte: Is this what you are looking for? WHENEVER SQLERROR EXIT SQL.SQLCODE; WHENEVER OSERROR EXIT FAILURE; Click to expand... Thanx for helping me man. Ekinox
