oracle+form+raise,Oracle Form Build-in(GO_BLOCK FIRST_RECORD FORM_TRIGGER_FAILURE)

GO_BLOCK Built-in

Description

GO_BLOCKnavigates to an indicated block. If the target block is non-enterable, an error occurs.

Syntax

PROCEDURE GO_BLOCK(block_name VARCHAR2);

FIRST_RECORD Built-in

Description

Navigates to the first record in the block's list of records.

Syntax

PROCEDURE FIRST_RECORD;

Raising the FORM_TRIGGER_FAILURE Exception

The FORM_TRIGGER_FAILUREexception 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 IS

BEGIN

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;