in reply to Re: (OT) sqlplus rollback on error
in thread (OT) sqlplus rollback on error

Okay, if I'm reading these error statements correctly, you can ROLLBACK, or EXIT sql.sqlcode, but not both.

I need it to rollback AND return an error code, in order to trigger our notification proticol and let someone know that something went wrong.

Any way to do that?

Replies are listed 'Best First'.
Re^3: (OT) sqlplus rollback on error
by Roy Johnson (Monsignor) on Oct 24, 2005 at 14:43 UTC
    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.
[reply]
[d/l]
      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]

In Section Seekers of Perl Wisdom