Running an Oracle sp - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

Running an Oracle sp

Author

Topic

hamishrock
Starting Member

2 Posts

Posted - 2011-08-05 : 09:28:12

I want to call an oracle sp from my SQL2005 box. I have a linked server configured with RPC , and my syntax so far is

Declare @V_Output varchar(200)
Exec ('Call mark_section_utc (''My book name'',''2011-03-27'',''01:00'',''2011-03-28'',''00:00'',''175'',''UTC'',''Output_Var'')', @V_Output OUTPUT) AT PIMSJ
However I am getting an error of
OLE DB provider "OraOLEDB.Oracle" for linked server "PIMSJ" returned message "ORA-06577: output parameter not a bind variable".

The sp works when I run it in an oracle enviroment ( SQL Developer)
Any Ideas welcome

hamishrock
Starting Member

2 Posts

Posted - 2011-08-15 : 09:28:41

The required code was

Exec ('Call mark_section_utc (''My book name'',''2011-03-27'',''01:00'',''2011-03-28'',''00:00'',''175'',''UTC'',?)', @V_Output OUTPUT) AT PIMSJ

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources