This discussion is archived
0 Replies Latest reply: Dec 3, 2012 2:28 AM by 977580 RSS

Named parameters calling a stored procedure under 11.2

977580 Newbie
Currently Being Moderated
Under ODAC 11.2 (11.2.0.3.20) I'm having trouble using named parameters when calling a stored procedure.

e.g.:

EXEC ('{
CALL SP(
     P_PARAM1 => 'blah',
     P_PARAM2 =>'blah'
     )}
')
AT [LINKED-SERVER]

works fine under 10.x (on a W2K3 box with SQL Server 2005).

But on W2K8 with 11.2 (SQL Server 2008) I get:

OLE DB provider "OraOLEDB.Oracle" for linked server "LINKED-SERVER" returned message "Unspecified error".
Msg 7323, Level 16, State 2, Line 2
An error occurred while submitting the query text to OLE DB provider "OraOLEDB.Oracle" for linked server "LINKED-SERVER".

Removing the parameter names and using positional parameters works OK.

Any thoughts?

Thanks.


Aaron

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points