Daily Oracle

short Oracle take-away tips that you can put to use in under an hour.

Friday, August 20, 2004

Exception Handling

Picked this up from asktom.oracle.com (http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1932043078402)

exceptions should be caught IF and ONLY IF you

a) expect them
b) can do something about them

eg: when no_data_found -- catch it, deal with it.

other exceptions that you cannot possibly recover from should not be caught and
the job queues will absolutely record the line number and everything exactly
right in the alert log.



Post a Comment

<< Home