HI GURUS,
WHAT IS THE PURPOSE OF LEXICAL PARAMETER IN REPORT
DEVELOPMENT.
- 2 Answers
- 5737 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anonymous
Lexical Parameter is used to replace the where, order by
conditions at run time.
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / abhisudipta
Yes the above answer is totally correct , in report u can
use if u want.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a record Group?
what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)
What are the different types of Package Procedure ?
Explain the different levels at which oracle form services interact.
How we can migrate the 6i report to 10g reports. What steps need to reuired?
what are bind variables?
I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent
If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
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 buil-in routines are used to display editor dynamicaly?
What are the built_in used to trapping errors in forms 4?
What is a radio Group?
Oracle General 
