Callin an Oracle SP

Giganews Newsgroups
Subject: Callin an Oracle SP
Posted by:  Paul (nothan…@btopenworld.com)
Date: Fri, 5 Aug 2011

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

Replies