Re: Exception handling inpl/sql

Originally posted by Steve Holdoway

> Hi Folks,

>

> I'm trying to devise a scheme whereby I can retrospectively put some

> error handling into existing in-house developed code. In order to do

> this, I'm trying to use local procedures within the procedures

> themselves, thereby upsetting the existing code as little as possible.

> I'm trying to take the suggestions in Steven Feuerstein's articles on

> otn (managing exceptional behaviour) as a basis for this 'project'

>

> What I would like to do is to encapsulate all of the exception

> handling at the procedure level into a private procedure as well. Will

> this work, or will the exception handler just shoot off back to the

> calling routine?

>

> Cheers,

>

>

> Steve

EXCEPTION keyword for each BEGIN END; block traps any exception raised. What you do with that afterwards is your choice. e.g.

EXCEPTION    WHEN OTHERS THEN        NULL; will kill the exception there. Just add RAISE; after NULL; to kick it back to the calling routine. No EXCEPTION block means that any exception will be kicked back to the calling routine.

Regards

/Rauf Sarwar

--
Posted via http://dbforums.com