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
- 2 Answers
- 4367 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
What do you understand by lov?
from where do u receive the information to develop report
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
List the different types of columns in oracle reports.
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
What is the difference between BPA AND Contract What are documents and test cases u followed
where do u put the report file
what is a package n what r the packages availbla in report
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
Why oracle forms required?
What are the various configuration files that are used by oracle forms?
List out the oracle forms configuration files?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
how do u place it in required folder
What is an SQL FORMS ?
