Pre Exam Test Practice
Ask a Question
Advertise on boostr.in
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.
Sep 16, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening