Pass Parameter from One Form to another

You can easily pass parameters from one form to another form by using this code. we need to transfer values of parent form to child form for different purposes for example for Login name ect….

1- Make one parent form in oracle forms builder

2- Write this code behind the button of parent form that will transfer parameters to child form.

  • Child form Name and location :       D:\SUB_CAT_SIZES.FMX
  • Child form parameter name:             P_SUB_CAT_ID (Destination parameter)
  • Parent form parameter name:        :SUB_CAT_ID (Source parameter)

 

————————————————-

DECLARE
temp_id paramlist;
RPT_NAME VARCHAR2(30);
BEGIN

temp_id := CREATE_PARAMETER_LIST(‘V_A’);
ADD_PARAMETER(temp_id,’P_SUB_CAT_ID’,text_parameter,:SUB_CAT_ID);
CALL_FORM(‘D:\SUB_CAT_SIZES.FMX’,NO_HIDE,DO_REPLACE,NO_QUERY_ONLY,TEMP_ID);
destroy_parameter_list(temp_id);
END;
———————————————

3- when you will press button then parameter data will transfer into child form and also call child form.
* If you like this article then please leave comments on it……. 🙂

  • md. abul monsur

    i am trying…..

  • Asad R

    YA