Home | Articles | Oracle Forms | Built In Routines | CALL_FORM built-in - Oracle Forms

CALL_FORM built-in - Oracle Forms

By
Font size: Decrease font Enlarge font

Runs an indicated form while keeping the parent form active. Form Builder runs the called form with the same Runform preferences as the parent form. When the called form is exited Form Builder 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.)  Form Builder will hide the calling form before drawing the called form.
    NO_HIDE  Form Builder will display the called form without hiding the calling form.
switch_menu    NO_REPLACE (The default.)  Form Builder will keep the default menu module of the calling form active for the called form.
    DO_REPLACE Form Builder 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.)  Form Builder 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 Form Builder 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, Form
       
    Builder will not share data between forms that have identical libraries attached (at design time).
    SHARE_LIBRARY_DATA  At runtime, Form Builder will share data between forms that have identical libraries attached (at design time).
paramlist_id    The unique ID Form Builder 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
Form Builder ignores the query_mode parameter when the calling form is running in

QUERY_ONLY mode. Form Builder runs any form that is called from a QUERY_ONLY form as a QUERY_ONLY form, even if the CALL_FORM syntax specifies that the called form is to run in NO_QUERY_ONLY (normal) mode.

    A parameter list passed to a form via CALL_FORM cannot contain parameters of type DATA_PARAMETER. Only text parameters can be passed with CALL_FORM.

    Some memory allocated for CALL_FORM is not deallocated until the Runform session ends. Exercise caution when creating a large stack of called forms.

When you execute CALL_FORM in a Pre-Logon, On-Logon, or Post-Logon trigger, always specify the DO_REPLACE parameter to replace the calling form’s menu with the called form’s menu. Failing to specify DO_REPLACE will result in no menu being displayed for the called form. (An alternative solution is to call the REPLACE_MENU built-in from a When-New-Form-Instance trigger in the called form.)
 
CALL_FORM examples


/* 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;

Subscribe to comments feed Comments (13 posted)

avatar
grademiners reviews 18/04/2018 12:29:34
In this session of the built in routines you can find the magic in your life and get the proper deals for the success from this place. Find this and enjoy the new oracles forum from this site.
avatar
topessayservicesau.com 19/04/2018 18:54:11
You can really change the environment with the different forums then get the proper details from this service. You can watch this forum to enjoy the best time here. Just see more information from this page and get the special contact.
avatar
Rooibos Tea 26/08/2018 19:12:41
Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post with people..
avatar
Raisins 26/08/2018 19:24:05
I really loved reading your blog. It was very well authored and easy to understand. Unlike other blogs I have read which are really not that good.Thanks alot!
avatar
Kiwano 26/08/2018 19:25:37
Interesting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks
avatar
Head Lice 26/08/2018 19:27:18
I will be interested in more similar topics. i see you got really very useful topics , i will be always checking your blog thanks
avatar
Burn Fat 26/08/2018 19:28:45
Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
avatar
Detox Water 26/08/2018 20:20:13
This website is remarkable information and facts it's really excellent
avatar
Copper 27/08/2018 00:01:41
This is very useful post for me. This will absolutely going to help me in my project.
avatar
Lycopene 27/08/2018 00:18:36
Just pure brilliance from you here. I have never expected something less than this from you and you have not disappointed me at all. I suppose you will keep the quality work going on.
1 2 next total: 13 | displaying: 1 - 10

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

Captcha
  • Email to a friend Email to a friend
  • Print version Print version
  • Plain text Plain text

Tagged as:

No tags for this article

Rate this article

0