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

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

OPEN_FORM Restrictions