Re^3: (OT) sqlplus rollback on error

My PL/SQL User's Guide and Reference indicates that you can do both. The syntax is:

WHENEVER SQLERROR {EXIT [SUCCESS|FAILURE|WARNING|n|variable] [COMMIT|R
+OLLBACK] | CONTINUE [COMMIT|ROLLBACK|NONE]}
[download]

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.

Caution: Contents may have been coded under pressure.

Comment on Re^3: (OT) sqlplus rollback on error Download Code

Replies are listed 'Best First'.
Re^4: (OT) sqlplus rollback on error by rashley (Scribe) on Oct 24, 2005 at 15:57 UTC
Yep, I had EXIT and ROLLBACK backwards. Now I just have to figure out if it'll return an exit code if the connection times out. That'll take some experimentation. Thanks	[reply]