|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions How to run concurrent request from an after report trigger in a report? (This report runs as a concurrent program, but this should launch another concurrent program to run after its execution based on its request ID as parameter to the next cocurrent program) Read Answers (2) | Asked by : Brijesh I need a sql query to identify all the responsibilities, menus that are attached to a concurrent program. If I pass a concurrent program as a parameter to the sql query, the output must show all the responsibilities and menus which attached to that concurrent program. Read Answers (2) | Asked by : vinodkumar .... becoz of the fact that out parameters are write only ... we only can assign values to out parameters but we can't assign out parameters value to any variable inside the procedure or function....but in my case I had created a simple procedure and used out parameters in it let give me the example of the code first ....>create or replace procedure test_out_parameter(out_parameter out number) isv_temp number;beginv_temp := out_parameter;out_parameter :=10 ;dbms_output.put_line (out_parameter);end Latest Answer : Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in Before Report.
For example:
IF :P_DATE_FROM IS ... Read Answers (1) | Asked by : heba How to use the Lexical Parameter in the Oracle 10g report? Latest Answer : Lexical parameter can be used in report for chaning column in query. These has to be defined in parameter with same name. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
