Executing an Oracle SP from SQL 2000

15 Jul 2005 2:42 PM

jaylou

Hi all,
I have a linked Oracle Database to one of my SQL servers. I can query the
database using openquery. Is there a wat to execute and pass parameters into
a Stored Proc on the Orcle DB? I had the Orcle DBA put the SP into a package
but I still can not get any data back. I have been trying to exec the SP and
Package with no luck.
Any help would be greatly appreciated.

TIA,
Joe

15 Jul 2005 3:52 PM

John Bell

Hi

Umachandar's post at: http://tinyurl.com/bwnxq may help.

John

Show quote

"jaylou" wrote:

> Hi all,
> I have a linked Oracle Database to one of my SQL servers. I can query the
> database using openquery. Is there a wat to execute and pass parameters into
> a Stored Proc on the Orcle DB? I had the Orcle DBA put the SP into a package
> but I still can not get any data back. I have been trying to exec the SP and
> Package with no luck.
> Any help would be greatly appreciated.
>
> TIA,
> Joe
>
>

15 Jul 2005 6:25 PM

jaylou

Thank you for the respose.

I had my Oracle DBA set the Proc into a package like your example. My
question now is, do you know how to pass parameters to the Ora Proc? I keep
getting an error saying there are no rows to return.

Thanks again,
Joe

18 Jul 2005 7:56 AM

John Bell

Hi

The example shows how to pass parameters, therefore if you have followed it
you r problem may be elsewhere. Check which version of MDAC you are using.
SP1 fixed an issue "294856 (http://support.microsoft.com/kb/294856/EN-US/)
FIX: No Rows are Returned on Linked Server Queries that Use an
IRowSetIndex::SetRange Call on Numeric Data " see
http://support.microsoft.com/default.aspx?scid=kb;en-us;290212

John

Show quote

"jaylou" wrote:

> Thank you for the respose.
>
> I had my Oracle DBA set the Proc into a package like your example. My
> question now is, do you know how to pass parameters to the Ora Proc? I keep
> getting an error saying there are no rows to return.
>
> Thanks again,
> Joe