Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Oracle SP vs. MS SQL Reporting Services

Author  Topic 

groundhog
Starting Member

9 Posts

Posted - 2005-07-24 : 11:00:52
Hi all,
I am trying to use an Oracle stored procedure to return a data set for my report in SQL Server Reporting Services.
First, is that doable?
If yes, my stored procedure has one output parameter which is the REFCURSOR for the returned data set. How can I define the parameter in the reporting services? And how can I handle the data set?
Any help? And useful links?

Thanks,
   

- Advertisement -