That is, you can EXIT or CONTINUE, and in either case, you can COMMIT or ROLLBACK. So just do EXIT and ROLLBACK. It should work.WHENEVER SQLERROR {EXIT [SUCCESS|FAILURE|WARNING|n|variable] [COMMIT|R +OLLBACK] | CONTINUE [COMMIT|ROLLBACK|NONE]}
In reply to Re^3: (OT) sqlplus rollback on error
by Roy Johnson
in thread (OT) sqlplus rollback on error
by rashley
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |