Returning Oracle Stored Procedure Resultset in SSRS
- Joel Lipman
- SQL Server Reporting Services
- Hits: 40308
So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes...
- Using Business Intelligence Development Studio v2008 (BIDS)
- SQL Server Reporting Services v2008 R2 (SSRS)
- Oracle SQL Developer v3 (you can use any equivalent, eg. SQL*Plus)
Why?
I think this is one of those very rare occasions that Microsoft people can say "it's so much easier using a Microsoft product to work with another Microsoft product" (ie "Seamless integration"). Yes, I'm trying to get an SSRS report to display the results from an Oracle stored procedure. I have a previous article describing a basic stored procedure in Oracle, this article aims to outline how to apply this to an SSRS 2008 R2 report.