SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

whenever sqlerror exit failure rollback in IDE's

523861Oct 9 2011 — edited Oct 9 2011

Hi all,

Sorry to cross-post, but there is a tendancy for people who have a bunch of Expertise in SQL/PL/SQL to not check other forums all that often so I am hoping for more results here.

I've started a thread over here:

9896329

The basic problem is that when I have a SQLplus script with

whenever sqlerror exit failure rollback

But when this is executed through an IDE like toad or SQL developer the IDE appears to ignore the exit command and continues executing the script regardless of any errors.

Has anyone encountered this problem previously and have a solution? or must I beat my deployment manager over the head to convince him to always use SQLPlus for database deployments?

This post has been answered by sb92075 on Oct 9 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2011

Added on Oct 9 2011

1 comment

1,310 views