Executing Oracle Sp in thru sql server

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 in thru sql server

Author

Topic

senthildba
Starting Member

7 Posts

Posted - 2004-06-08 : 04:06:50

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

Please Help

Senthil Nath.M

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-08 : 12:14:36

What is the error?

Tara

senthildba
Starting Member

7 Posts

Posted - 2004-06-09 : 06:04:48

the error excuting the oracle sp in sql server 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.]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources