Keith Ramsey's Business Intelligence Blog

Browse by Tags

All Tags » ORACLE (RSS)
Simple Stored Procedure to return data to a SSRS Report from Oracle
If you are like me, SQL Server is a breeze to write a Stored Procedure against and Oracle isn't as intuitive. I had a report that simply needed to do the following: 1. Run a query in Oracle. 2. Return the data to Reporting Services so that it could report...
Dynamic ORACLE SP for calling a linked server database environment based on a parameter.
I haven't posted anything here yet on this blog, so I thought I'd pull some lesson I learned a while back and use it as a post. If it helps you; great, if not, no worries. The problem I tried to solve involved 5 or 6 Oracle environments that need to have...