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:
Other Built-in subprograms exist to perform operations on data in the form or in the database:
Still others can be used to control the display of interface objects at runtime:
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.
Trigger Definition Level and Scope
Creating a trigger in the Object Navigator
About writing SQL statements in triggers
Overview of trigger categories