|need help [message #254164]
||Thu, 26 July 2007 01:05
Registered: November 2006
hi this is preeti iam new to apps and i want some information pls hlep|
I have got some doubts in reports
1. what is the major diff b/w lexical and bind reference
2. In a report how to create multiple layouts.give me instructions to proceed
3.I have a report and I have to write a query in such away that if I pass parameter a one report should display and if i pas b the another report should display if it is possible how can we writhe query
4. what r user_exits in apps and where do we write in reports
| Re: need help [message #254187 is a reply to message #254164]
||Thu, 26 July 2007 02:09
Registered: September 2006
Some of the answers for your questions are as follows:
1. Differences Between Lexical and Bind References:
BIND VARIABLE :
-- Are used to replace a single value in sql, pl/sql
-- Bind Variables may be used to replace expressions in select, where, group, order by, having, connect by, start with cause of queries.
-- Bind reference may not be referenced in FROM clause (or) in place of reserved words or clauses.
-- You can use lexical reference to replace the clauses appearing AFTER select,from, group by, having, connect by, start with.
-- You can’t make lexical reference in a pl/sql statements.
2. User Exits
A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.
You can write the following types of user exits:
* ORACLE Pre-compiler user exits
* OCI (ORACLE Call Interface) user exits
* Non-ORACLE user exits
You can also write a user exit that combines both the ORACLE Pre-compiler interface and the OCI. User exits can perform the following tasks:
* Perform complex data manipulation
* Pass data to Report Builder from operating system text files
* Manipulate LONG RAW data
* Support PL/SQL blocks
* Control real time devices, such as a printer or a robot
Example on User Exits
A small example on User Exits.
Let us say you want to print flex field information in one of your apps reports.
Then you use the following user exit to print the flex field information.
The syntax of using this user exist is as follows:
Best Regards & Thanks,
Arun Reddy ,
Oracle Apps Techno Functional Consultant,
[Updated on: Thu, 26 July 2007 02:10]
Report message to a moderator