Oracle Form Build-in(GO_BLOCK FIRST_RECORD FORM_TRIGGER_FAILURE)

GO_BLOCK Built-in

Description
GO_BLOCK navigates 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_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 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;

 

转载于:https://www.cnblogs.com/djjddjdj/p/10071293.html