Errors in Oracle are usually divided into compile-time errors and run-time errors. Exceptions occur during PLSQL execution.
Errors in Oracle are usually divided into compile-time errors and run-time errors. Exceptions occur during PL/SQL Execution.
When the sub-block handles exceptions by itself, it can be terminated normally, and the control can be handed over to the external block immediately after the END statement of the sub-block.
However, if PL/SQL encounters an exception but the current block does not have a processor for the exception, it will find whether the external block has a processor, if no external block can handle this exception, an unhandled exception will occur in the host environment.
When an exception is transmitted to an external block, the code waiting for execution in the current block is no longer executed.
The advantage of this method is that the internal block only handles its own unique errors and leaves the general exception handling to the external block.
Raise_Application_ErrorProcess