0 Replies Latest reply: Dec 3, 2012 4:28 AM by 977580 RSS

    Named parameters calling a stored procedure under 11.2

    977580
      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