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!

Function have multiple exception handlers

838123Mar 9 2011 — edited Mar 9 2011
Hi,

Can a particular function have multiple exception handler blocks

For eg

Begin
..................
.................
BMS_XMLQuery.setRaiseNoRowsException(XYZ,true); -- raises an exception when no data is found
..........
Exception
when no_data_found then

................
...........
raise user_defined_exception

Exception
when user_defined_exception
then .................
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2011
Added on Mar 9 2011
14 comments
20,220 views