First U need to create one Param-List object inside the form like as below

how to create parameterised form in oracle 10g?
and create another form from the value of the form?
AND how to assign value to a parameter?
sincerly your
mamun

Question Posted / sudipta santra

2 Answers
4856 Views
I also Faced
E-Mail Answers

Answer Posted / sudipta santra

First U need to create one Param-List object inside the form
like as below:-

list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form2.fmx',no_hide,no_replace,
no_query_only,list_id);

in the Form2.fmb: You need to catch those parameter value in
either trigger Pre-Form or in trigger When-New-Form-Instance.

If you have any doubt then please drop me a mail about your
confusion on : sudipta_santra@infosys.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between flex mode and confined mode?

1038

i am writing a query select EmpNo from Emp how can i call in after parameter form

2111

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2898

what is oracle forms?

1102

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2012

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1670

What is an SQL FORMS ?

2776

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1150

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1894

where do u put the report file

2091

what exactly u write in when_new_form_instance

3440

why the Ctl file u put only in bin folder why not in other folder

2032

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?