Solved

newbee question on CALL_FORM

Posted on 2004-03-31
4
1,008 Views
Last Modified: 2012-05-04
Here is what I am trying to do.

I am trying to pass the value of :contact.contactid from the parent form to the child form. From reading in the book this is how it is done but this is not working. I get an error with the 'QUERY_CONTACTID'. Can someone plz help?

DECLARE
      v_paramlist_id            PARAMLIST;
      v_paramlist_name      VARCHAR2(15) := 'form_params';
BEGIN
      --set up param list
      v_paramlist_id := get_parameter_list(v_paramlist_name);
      IF NOT id_null(v_paramlist_id)
            THEN
              destroy_parameter_list(v_paramlist_id);
      END IF;
      --
      -- Add paremeters
      add_parameter(v_paramlist_id, 'QUERY_CONTACTID',TEST_PARAMETER,To_Char(:CONTACTS.CONTACTID));
      CALL_FORM(d:\forms\act2.fmx', no_hide, no_replace, no_query_only,share_library_data, v_paramlist_id);
END;
0
Comment
Question by:uTab
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
aabbas earned 125 total points
ID: 10724576
Exact error (e.g. FRM....) would help tracing the true reason of error. Anyway...

First, you have typo in "add_parameter..." line. It's acually TEXT_PARAMETER. Second, you have told Oracle Forms that pass on To_Char(:CONTACTS.CONTACTID) to the parameter QUERY_CONTACTID of child form, means you must have a parameter in your child form with this particular name. So, the value passed as parameter argument from parameter will be accepted by the child form as a parameter.

You will get a PARAMETER node in Form's Object Navigator....

Hope, it will help.

Best of luck.
0
 

Author Comment

by:uTab
ID: 10724796
How do I add the Query_contact parameter to the child form?
0
 

Author Comment

by:uTab
ID: 10724844
I forgot the error that I am receiving:

FRM-47009: Cannot add parameter QUERY_CONTACT to parameter list: invalid list ID.

Thank you
0
 

Author Comment

by:uTab
ID: 10727654
I ma not getting errors any longer but how do I check to make sure it is passing the proper vairiable or set something in the form to it because contactid := QUERY_CONTACT gives me an error.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now