Saturday 26 May 2012

What happens if an exception is not handled in a sub-block? | PL SQL

 If an exception is not handled in a sub-block, the exception propagates to the enclosing blocks until the associated handler is found. If none of the blocks has a handier for the exception, an unhandled exception error is passed back to the   host environment as follows:
ORA-06510: PL/SQL: unhandled user-defined exception