Hi all,
I have linked an Oracle database to mone of my SQL servers. I had my Oracle DBA place a stored Proc in a package. He created the package from sample I have found on the MS help pages and Google search on running linked Procs.
I am trying to run the Proc using openquery in t-sql. When I run the query I get an error saying thre are no columns in the table to return. I am guessing the reason there is nothing to return is because I am not passing the parameters correctly.
Does anyone know how to pass Paramters to a linked Oracle Proc?
TIA,
Joe