Support for return codes and sqlplus "whenever ..."
Brought to you by:
drautzburg
Menu
▾
▴
#4 Support for return codes and sqlplus "whenever ..."
This patch adds support from return codes (exit n) and sqlplus "whenever ..."
The whenever command is also extended to allow trapping of specific error messages,
for example
> whenever sqlerror exit 3
> whenever sqlerror=OR-06502 continue
would exit with return code 3 on all SQL errors, except ORA-06502.
Unfortunately, this removes support for the senora "set sqlerror ..." in favour of SQL+ compatability.
Also, a new error class (dberror) has been added to allow trapping of non-sql errors (for example connection error)
> whenever dberror exit 127
Hope this is useful for you
Cheers
Beorn
Patch for whenever command and exception handling
Fixed a typo in the source changes.