Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server

Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server

Post by Richard Ur » Thu, 17 Aug 2006 17:18:11


Hi,
I'm trying to call an Oracle stored procedure from Sql server and I have
this error message

Could not execute procedure 'INTEGRE_INTERNET' on remote server 'ORA_DEV1'.
[OLE/DB provider returned message: One or more errors occurred during
processing of command.]
[OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]

My linked server seems to be ok, I can run a "Select " query from the query
analyser to a Oracle table but I can't run a oracle stored procedure...

Do you have any idea ?

thanks

richard
 
 
 

Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server

Post by Richard Ur » Sat, 19 Aug 2006 21:25:13

Hi,
I'm trying to call an Oracle stored procedure from Sql server and I have
this error message

Could not execute procedure 'INTEGRE_INTERNET' on remote server 'ORA_DEV1'.
[OLE/DB provider returned message: One or more errors occurred during
processing of command.]
[OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]

My linked server seems to be ok, I can run a "Select " query from the query
analyser to an Oracle table but I can't run an oracle stored procedure...

Do you have any idea ?

thanks

richard