Returns a value that indicates the outcome of the action most recently performed during the current Runform session.
Outcome |
Returned Value |
---|---|
success |
FALSE |
failure |
TRUE |
fatal error |
FALSE |
If no action has executed in the current Runform session, FORM_FAILURE returns FALSE.
Use FORM_FAILURE to test the outcome of a Built-in to determine further processing within any trigger. To get the correct results, you must perform the test immediately after the action executes. That is, another action should not occur prior to the test.
Note: "Another action" includes both Built-ins and PL/SQL assignment statements. If another action occurs, FORM_FAILURE may not reflect the status of the Built-in you are testing, but of the other, more recently executed action. A more accurate technique is, for example, when performing a COMMIT_FORM, to check that the SYSTEM.FORM_STATUS variable is set to 'QUERY' after the operation is done.
FUNCTION FORM_FAILURE;
Built-in Type unrestricted function
Returns BOOLEAN
Enter Query Mode yes
None.
/*
** Built-in: FORM_FAILURE
** Example: Determine if the most recently executed Built-in
** failed.
*/
BEGIN
GO_BLOCK('Success_Factor');
/*
** If some validation failed and prevented us from leaving
** the current block, then stop executing this trigger.
**
** Generally it is recommended to test
** IF NOT Form_Success THEN ...
** Rather than explicitly testing for FORM_FAILURE
*/
IF Form_Failure THEN
RAISE Form_Trigger_Failure;
END IF;
END;