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

    Named parameters calling a stored procedure under 11.2

      Under ODAC 11.2 ( I'm having trouble using named parameters when calling a stored procedure.


      EXEC ('{
      CALL SP(
           P_PARAM1 => 'blah',
           P_PARAM2 =>'blah'

      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?