Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

List the different types of columns in oracle reports.

1005


difference between global n context sensitive segments?

2679


what are bind variables?

1093


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

3005


What do you understand by oracle forms?

1050


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1212


how do u place it in required folder

1940


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1983


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

1163


what is difference between group above and group left report

3827


what are the oracle forms services components include?

1035


if some data is not transfered where it will get stored

1945


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

2217


what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1026


what are the new features introduced in oracle form services in 11g release 2?

1039