Calling an Oracle Stored Procedure from Report Services...

[hneal98]

Has anyone had any experience with using an Oracle stored procedure as a dataset for reporting services? If so, can you tell me how you set it up to return the data to reporting services?

I want to do this, but i know you cannot do like in SQL Server where you can end the stored proc with a select statement to return the data.

Any help would be appreciated.

Thanks

 

[GHolden]

Hi,

you need to use cursors in oracle to return recordset:

http://www.oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets.php

Should then just be the same as SQL Server from the SSRS end.


There are two ways to write error-free programs; only the third one works.

 

[hneal98]

Thanks for the info. I will give it a try.