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

About Calling Built-in Subprograms in Triggers

Oracle Forms includes over 100 Built-in subprograms that can be called from triggers. A Built-in subprogram is a packaged procedure or function that is always available within Oracle Forms. Built-in subprograms are available to handle a variety of application functions. For example, to programmatically move the input focus from one item to another, call one of the following Built-in subprograms:

NEXT_ITEM

GO_ITEM

NEXT_BLOCK

GO_BLOCK

NEXT_RECORD

Other Built-in subprograms exist to perform operations on data in the form or in the database:

CLEAR_RECORD

EXECUTE_QUERY

DELETE_RECORD

COMMIT_FORM

ENTER_QUERY

Still others can be used to control the display of interface objects at runtime:

MOVE_WINDOW

SHOW_LOV

HIDE_WINDOW

SHOW_ALERT

SHOW_EDITOR

The following example shows the text of a When-Button-Pressed trigger. Pressing the button displays a dialog box called order_info_window that allows operators to enter information about an order:

/* When-Button-Pressed trigger: */
Show_Window('order_info_window');

This trigger has only one statement, the call to the Built-in subprogram SHOW_WINDOW. The SHOW_WINDOW subprogram is a procedure that displays the window named in its argument List.

In the Object Navigator, you can browse a List of Oracle Forms Built-ins under the Built-in Packages node. The Standard Extensions package includes the core Oracle Forms Built-ins. Other packages provide specialized functionality for specific application purposes.


Types of Events

Trigger Definition Level and Scope

Creating a trigger in the Object Navigator

Setting trigger properties

About writing trigger code

About compiling triggers

About writing SQL statements in triggers

Overview of trigger categories

About restricted Built-in subprograms

Built-ins overview

About Oracle Forms packages

About PL/SQL in Oracle Forms