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
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
List the different types of columns in oracle reports.
difference between global n context sensitive segments?
what are bind variables?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
What do you understand by oracle forms?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
how do u place it in required folder
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
what is difference between group above and group left report
what are the oracle forms services components include?
if some data is not transfered where it will get stored
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
what are the new features introduced in oracle form services in 11g release 2?