How i can passing parameters between oracle forms ??
help me >>
I think you want to do following
1) press button on form1
2) in pl sql code of button, open form2 with some parameter
Steps for achiving this
1) in form two in object navigator mode you will file one node called PARAMTERS
add you paratmeter as many you want (for eg. p_1, p_2, p_3)
2) set form 2 in modal mode, so that after before closing form2 user can not access form1
3) in form one pl/sql code of button
DECLARE
pl_id ParamList;
pl_name VARCHAR2(10) := 'paramlist';
theformname VARCHAR2(50);
BEGIN
theformname := 'form2';
pl_id := GET_PARAMETER_LIST(pl_name);
IF ID_NULL(pl_id) THEN
pl_id := CREATE_PARAMETER_LIST(pl_name);
ELSE
DELETE_PARAMETER(pl_id,'p_1');
DELETE_PARAMETER(pl_id,'p_2');
DELETE_PARAMETER(pl_id,'p_3');
END IF;
Add_Parameter(pl_id,'p_1',TEXT_PARAMETER,'value1');
Add_Parameter(pl_id,'p_2',TEXT_PARAMETER,'value2');
Add_Parameter(pl_id,'p_3',TEXT_PARAMETER,'value3');
CALL_FORM(theformname,no_hide,do_replace,no_query_only,pl_id);
END;
Whoa!! That's too much work!
Use Global Variables...
-- Set your Variable
:Global.Foobar = '42';
-- Call your Form
Call_Form ();
-- Test or reassign your Variable
:Block.Item = :Global.Foobar;
-- Destroy your Variable
Erase ('Global.Foobar');
-- Nice and simple!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.