Re: Oracle reports 10g and stored proc (ref cursor)

joet11_at_comcast.net wrote:

> I did find the following approach which appears to work. Any comments
> as to whether this is the correct approach would be appreciated:
> I created a query in the data model as follows: (it calls the procedure
> P_TEST which exists in the db and the ref cursor is defined in the
> package PKG_TEST)
>
> function QR_1RefCurDS return PKG_TEST.CursorTEST is
> out_cursor PKG_TEST.CursorTEST;
> begin
> P_TEST(42020,OUT_CURSOR);
> return OUT_CURSOR;
> end;
>
>
>
> Thanks - Joe
>
>
> joet11_at_comcast.net wrote:
>

>>Hi;
>>
>>We are looking at switching to Oracle Reports 10g from Crystal

>> I am trying to migrate one of the Crystal reports.  The Crystal

>>gets its data input by calling an Oracle stored procedure (existing

>>the DB) which returns a ref cursor.
>>
>>I'd like to use that same stored procedure to feed the Oracle report.
[Quoted] >>However, I can only find documentation which describes how to save a
>>procedure into an external library via the Oracle reports
>>functionality.  Then attach that external libray to other reports.
>>
>>I don't want to do that as there is no need to create it again.  I
>>simply want to call the existing stored procedure which already

>>in the DB and returns a ref cursor.
>>
>>Any help on how this can be done will be greatly appreciated.
>>
>>Thanks - Joe

If you have any problems contact me off-line and I can put you in touch [Quoted] with the person that guest lectures for me at the University of Washington on Oracle Reports.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)