0 Replies Latest reply: Aug 5, 2010 6:22 PM by patrickmburke RSS

    Problem Invoking SQL Server 2008 procedure with @parameters

    patrickmburke
      Hi There,

      We are currently running into a problem running integration with a sql server 2008. The sql server procedure has the @ sign for parameters.

      The error we got was
      "... An error occurred while preparing and executing the XXX_60.dbo.tstInvoice API. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function 'tstInvoice' expects parameter '@InvID', which was not supplied. ". The invoked JCA adapter raised a resource exception...

      This is a straight 11.1.1.2 SOA Suite deployment with no further patches.

      has anyone come accross this?

      Thanks,
      P

      I have moved this to the BPEL Forum. [ http://forums.oracle.com/forums/thread.jspa?threadID=1110814 |http://forums.oracle.com/forums/thread.jspa?threadID=1110814]
      Edited by: pburke on 5/08/2010 16:20