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
pl_name VARCHAR2(10) := 'paramlist';
theformname := 'form2';
pl_id := GET_PARAMETER_LIST(pl_name);
IF ID_NULL(pl_id) THEN
pl_id := CREATE_PARAMETER_LIST(pl_name);
Whoa!! That's too much work!
Use Global Variables...
-- Set your Variable
:Global.Foobar = '42';
-- Call your Form
-- Test or reassign your Variable
:Block.Item = :Global.Foobar;
-- Destroy your Variable
-- Nice and simple!
Hi guys. I am trying to create a program where the user inputs an integer and the program will cout the nth prime number. Unfortunatly when I try to cout ...
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...
I have two tables. MODELS and AUTOMOBILES. And procedure which export all models with name that user inputs and their price(stored in AUTOMOBILES).
create or REPLACE procedure modelzz( VAR_MODEL IN ...