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;
Member Avatar for hfx642

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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.