About Handling Exceptions Raised in Triggers
When you write triggers that include SQL statements, PL/SQL statements, or calls to user-named subprograms, you should consider how you will handle any exceptions that are raised. Depending on the behavior desired, you can respond to exceptions in one of three ways:
- Write exception handlers in the trigger to handle all raised exceptions.
- Take advantage of Oracle Forms default post-failure trigger processing
by deliberately omitting exception handlers; when an exception is raised,
the trigger fails, and the appropriate post-failure processing occurs.
- Write exception handlers for only the specific exceptions you want to handle
in the trigger, and leave any other exceptions unhandled to deliberately cause
the trigger to fail.
Related topic
About handling runtime errors in triggers