| Please help. [message #89877] |
Sun, 15 August 2004 08:10  |
Anon
Messages: 6
Registered: October 1999
|
Junior Member |
|
|
We're migrating from PRO*C to Oracle Reports. I am a new employee and am clueless how to proceed. My boss says he doesn't *know* PRO*C. It seems to be taking upto 11 arguments and I don't know what these arguments are. Should I ask the client? I want to avoid doing so unless I am absolutely sure I cannot solve this on my own.
Is there a standard procedure to be followed when migrating to any Oracle tool from an existing Oracle tool? Please guide me in this regard.
Thanks in advance.
|
|
|
|
| Re: Please help. [message #89878 is a reply to message #89877] |
Sun, 15 August 2004 23:08  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Copy the Report's Query from Pro*C code into Report builder Data modeler.
Make us of User parameters for the input parameters.
E.g.
Your query receives a Deptno from the calling Program,
So create a User parameter in your Report & use it as follows in your query:
Select * from DEPT
where deptno=:Deptno;
Note that user parameter DEPTNo is used as :DEPTNO in the query.
If you need to pass large where clause the make use of Lexical parameters i.e.
Make a User parameter P_QUERY in your report & then use it as follows:
Select * from dept
&P_QUERY;
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
