Re: unable to catch Exception

Have you read the Oracle documentation on this issue? Please look at the PL/SQL User's Guide:S

http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm

Chapter 10 talks about Exception Handling. Pay particular attention to the section titled "How PL/SQL Exceptions Propagate". After you've read that, look at the next section titled "Reraising a PL/SQL Exception".

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown