Function have multiple exception handlers
838123Mar 9 2011 — edited Mar 9 2011Hi,
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 .................