Creating Report using the Procedure [message #235052] |
Thu, 03 May 2007 20:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
garimella_aditya
Messages: 8 Registered: May 2007 Location: India
|
Junior Member |
|
|
Hi all,
I have the PL/SQL Procedure where i have the in parameters as well as the out parameters. I want to create the report using this procedure. Can i do it? if so how
regards,
aditya.
|
|
|
Re: Creating Report using the Procedure [message #235151 is a reply to message #235052] |
Fri, 04 May 2007 03:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Stored procedure is not among possible report data sources. If your procedure returns only one value, you might try to create a PL/SQL program unit and return this value into a user-defined parameter and display it in report. However, I'm not sure how to display, for example, a PL/SQL table. It can be done in Forms, though, but you are not interested in it.
Could you, perhaps, use your procedure as an SQL query in this report? IN parameters would be report's user-defined parameters, and you'd simply return the resulting record set.
Of course, there might be a way to do that, but - I can't help you about it.
|
|
|
|
|