Executing Oracle SP thru SQLSERVER

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Executing Oracle SP thru SQLSERVER

Author

Topic

senthildba
Starting Member

7 Posts

Posted - 2004-06-09 : 06:05:52

Hi all
Can any one tell me how to execute an oracle SP thru SQL SERVER Query analyzer .I would be much helpfull .
I have created a link server to oracle from SQL SERVER but i cant execute my Oracle SP in SQL SERVER

The error i am getting is
Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'XS_SQL_SERVER' on remote server 'ORADB'.
[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.]

Please Help

Senthil Nath.M

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2004-06-09 : 06:12:49

Creating a duplicate.....(http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35988)....doesn't get it solved faster.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources