A script-enabled browser is required for this page to function properly.

Raising the FORM_TRIGGER_FAILURE Exception

The FORM_TRIGGER_FAILURE exception is a predefined PL/SQL exception available only in Oracle Forms. Because it is predefined, you can raise this exception without having to first define it in the declarative section of a trigger or user-named subprogram.

Indeed, this exception is used so often in Oracle Forms that it is common to write a user-named procedure that can be used to test the outcome of Built-in procedures and functions:

/* user-named subprogram: */
PROCEDURE Check_Builtin ISBEGIN
 IF NOT Form_Success THEN
  RAISE Form_Trigger_Failure;
 END IF; END;

You can define the procedure in a form or an attached library and then call it from any trigger in your form:

/* When-Button-Pressed Trigger: */
Go_Block('xyz_block');
Check_Builtin;

Note: Do not use the internal error code associated with the FORM_TRIGGER_FAILURE exception, because the internal error code can change without notice.


About using PL/SQL exception handling in triggers

About trigger failure results

About handling exceptions raised in triggers

About evaluating the success or failure of Built-ins

Handling errors in Built-in subprograms

Handling errors in user-named triggers

Error handling for stored procedures

User-defined exceptions