OPEN_FORM Built-in
Description
Opens the indicated form. Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time.
Syntax
PROCEDURE OPEN_FORM
(formmodule_name VARCHAR2);
PROCEDURE OPEN_FORM
(form_name VARCHAR2,
activate_mode NUMBER);
PROCEDURE OPEN_FORM
(formmodule_name VARCHAR2,
activate_mode NUMBER,
session_mode NUMBER);
PROCEDURE OPEN_FORM
(formmodule_name VARCHAR2,
activate_mode NUMBER,
session_mode NUMBER,
data_mode NUMBER);
PROCEDURE OPEN_FORM
(formmodule_nameVARCHAR2,
activate_mode NUMBER,
session_mode NUMBER,
paramlist_name VARCHAR2);
PROCEDURE OPEN_FORM
(formmodule_name VARCHAR2,
activate_mode NUMBER,
session_mode NUMBER,
paramlist_id PARAMLIST);
PROCEDURE OPEN_FORM
(formmodule_name VARCHAR2,
activate_mode NUMBER,
session_mode NUMBER,
data_mode NUMBER,
paramlist_name VARCHAR2);
PROCEDURE OPEN_FORM
(formmodule_name VARCHAR2,
activate_mode NUMBER,
session_mode NUMBER,
data_mode NUMBER,
paramlist_id PARAMLIST);
Built-in Type restricted procedure
Enter Query Mode no
Parameters:
- formmodule_name
-
- The name of the form to open. Datatype is VARCHAR2. Required
-
- activate_mode
-
- ACTIVATE (The default.) Sets focus to the form to make
it the active form in the application.
NO_ACTIVATE Opens the form but does not set focus to the
form. The current form remains current.
-
- session_mode
-
- NO_SESSION (The default.) Specifies that the opened form
should share the same database session as the current form. POST and COMMIT
operations in any form will cause posting, validation, and commit processing
to occur for all forms running in the same session.
SESSION Specifies that a new, separate database
session should be created for the opened form.
-
- data_mode
-
- NO_SHARE_LIBRARY_DATA (The default.) At runtime, Oracle Forms will not share data between forms that have identical libraries
attached (at design time).
SHARE_LIBRARY_DATA At runtime, Oracle Forms
will share data between forms that have identical libraries attached (at design
time).
-
- paramlist_name
-
- The name of a parameter list to be passed to the opened form. Datatype is
VARCHAR2.
-
- paramlist_id
-
- The unique ID that Oracle Forms assigns to the parameter list at
the time it is created. Use the GET_PARAMETER_LIST function to return the
ID to a variable of type PARAMLIST.
Usage Notes
- Whether you open a form with ACTIVATE or NO_ACTIVATE specified, any startup
triggers that would normally fire will execute in the opened form. (However,
see the usage note regarding SESSION-specified below.)
- When you open a form with ACTIVATE specified (the default), the opened form
receives focus immediately; trigger statements that follow the call to OPEN_FORM
never execute.
- When you open a form with NO_ACTIVATE specified, trigger statements that
follow the call to OPEN_FORM will execute after the opened form has been loaded
into memory and its initial start-up triggers have fired.
- When you open a form with SESSION specified, the PRE-LOGON, ON-LOGON, and
POST-LOGON triggers will not fire.
- If the form that issues the OPEN_FORM Built-in is running in QUERY_ONLY
mode, then the opened form will also run in QUERY_ONLY mode.
- For most applications, you should avoid using OPEN_FORM with forms that
contain root windows. Because there can be only one root window displayed
at a time, canvases that are assigned to the root window in the current form
and in the opened form will be displayed in the same window. This causes the
opened form to "take over" the root window from the original form,
thus hiding the canvases in the original form partially or completely.
OPEN_FORM Restrictions
- You can set session On for all Runform invocations by setting the FORMSnn_SESSION
environment variable to TRUE. When you set the FORMSnn_SESSION variable, all
Runform invocations inherit its setting, unless you override the environment
variable by setting the Session option from the Runform command line.
- If you set session_mode to SESSION when you use OPEN_FORM to create
a multiple-form application, you cannot set data_mode to SHARE_LIBRARY_DATA
(Oracle Forms will display a runtime error message).