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 220.127.116.11 SOA Suite deployment with no further patches.
has anyone come accross this?
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