Forum Stats

  • 3,838,691 Users
  • 2,262,394 Discussions
  • 7,900,734 Comments

Discussions

Named parameters calling a stored procedure under 11.2

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
This discussion has been closed.