Skip to Main Content

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!

Killing a package with multiple exception blocks

580456Jan 7 2008 — edited Jan 9 2008
Hello,

I have a package with multiple stored procedures and functions in it that refer to each other. I also have a main() procedure that basically does a ton of different calculations, and I divided the procedure into multiple BEGIN...END blocks to easily identify bugs and debug using exception handlers. My question is, is there a way to create some kind of a "kill" procedure/command that would kill the entire package's process if ANY errors occur?

Basically the program needs to stop as soon as it finds an error, and it's not doing that now.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2008
Added on Jan 7 2008
13 comments
502 views