Organizational Research By

Surprising Reserch Topic

how do i exit a script in sqlplus when an error occurs and return to the sqlplus


how do i exit a script in sqlplus when an error occurs and return to the sqlplus  using -'oracle,sqlplus'

I have some scripts that get run often, always from within a connected SQLPlus session.

I need a way to exit the script when an error occurs, without disconnecting or exiting SQLPlus itself.  100% of the time, when an error occurs, the connected DBA will need to issue one or more commands into the session.  100% of the time, when an error occurs, there are other SQLPlus statements (and thus must be outside of a BEGIN..END;) later on in the script that must not be executed or serious problems could arise.

NOTE:  If you suggest WHENEVER SQLERROR EXIT then you didn't read the above text.  That will disconnect and exit SQLPlus in addition to the script, which is not acceptable behavior.
    
asked Sep 21, 2015 by girisha
0 votes
3 views



Related Hot Questions



Government Jobs Opening


...