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;

 

posted @ 2018-12-05 15:39  djjddjdj  阅读(656)  评论(0)    收藏  举报