• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1027
  • Last Modified:

newbee question on CALL_FORM

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?

      v_paramlist_id            PARAMLIST;
      v_paramlist_name      VARCHAR2(15) := 'form_params';
      --set up param list
      v_paramlist_id := get_parameter_list(v_paramlist_name);
      IF NOT id_null(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);
  • 3
1 Solution
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.
uTabAuthor Commented:
How do I add the Query_contact parameter to the child form?
uTabAuthor Commented:
I forgot the error that I am receiving:

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

Thank you
uTabAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now