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

CALL_FORM Built-in

Description

Runs an indicated form while keeping the parent form active. Oracle Forms runs the called form with the same Runform preferences as the parent form. When the called form is exited Oracle Forms processing resumes in the calling form at the point from which you initiated the call to CALL_FORM.

Syntax

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER,
switch_menu
NUMBER);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER,
switch_menu
NUMBER,
query_mode
NUMBER);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER,
switch_menu
NUMBER,
query_mode
NUMBER,
data_mode NUMBER);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER,
switch_menu
NUMBER,
query_mode
NUMBER,
paramlist_id
PARAMLIST);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER,
switch_menu
NUMBER,
query_mode
NUMBER,
paramlist_name
VARCHAR2);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER,
switch_menu
NUMBER,
query_mode
NUMBER,
data_mode
NUMBER,
paramlist_id
PARAMLIST);

PROCEDURE CALL_FORM
(formmodule_name VARCHAR2,
display
NUMBER,
switch_menu
NUMBER,
query_mode
NUMBER,
data_mode
NUMBER,
paramlist_name
VARCHAR2);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

formmodule_name 
 
The name of the called form (must be enclosed in single quotes). Datatype is VARCHAR2.
 
display 
 
HIDE (The default.) Oracle Forms will hide the calling form before drawing the called form.

NO_HIDE Oracle Forms will display the called form without hiding the calling form.
 
switch_menu 
 
NO_REPLACE (The default.) Oracle Forms will keep the default menu module of the calling form active for the called form.
 
DO_REPLACE Oracle Forms will replace the default menu module of the calling form with the default menu module of the called form.
 
query_mode
 
 NO_QUERY_ONLY (The default.) Oracle Forms will run the indicated form in normal mode, allowing the end user to perform inserts, updates, and deletes from within the called form.
 
QUERY_ONLY Oracle Forms will run the indicated form in query-only mode, allowing the end user to query, but not to insert, update, or delete records.
 
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_id 
 
The unique ID Oracle Forms assigns when it creates the parameter list. You can optionally include a parameter list as initial input to the called form. Datatype is PARAMLIST.
 
paramlist_name 
 
The name you gave the parameter list object when you defined it. Datatype is VARCHAR2.

CALL_FORM Restrictions

CALL_FORM Example

/* Example 1:   ** Call a form in query-only mode.
*/
BEGIN
  CALL_FORM('empbrowser', no_hide, no_replace, query_only);
END;

/* Example 2:
** Call a form, pass a parameter list (if it exists)
*/
DECLARE
  pl_id        PARAMLIST;
  theformname  VARCHAR2(20);
BEGIN
  theformname := 'addcust';

 /* Try to lookup the 'TEMPDATA' parameter list */
   pl_id := GET_PARAMETER_LIST('tempdata');
  IF ID_NULL(pl_id) THEN
    CALL_FORM(theformname);
  ELSE
    CALL_FORM(theformname,
              hide,
              no_replace,
              no_query_only,
              pl_id);
  END IF;
 
  CALL_FORM('lookcust', no_hide, do_replace, query_only);
END;