While invoking stored procedure from JCA adapter from OSB 11g,Getting error out with this error message "<con:errorCode>BEA-380002</con:errorCode>
<con:reason>Invoke JCA outbound service failed with connection error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/cm.cpm_1.0/resources/interfaces/getBalances/getAccountBalance [ getAccountBalance_ptt::getAccountBalance(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'getAccountBalance' failed due to: Stored procedure invocation error.
Error while trying to prepare and execute the SSB_USER.VF_SELFCARE.GETACCOUNTBALANCE API.
An error occurred while preparing and executing the SSB_USER.VF_SELFCARE.GETACCOUNTBALANCE API. Cause: java.sql.SQLException: ORA-03111: break received on communication channel nested exception is:
Stored procedure invocation error".This is an intermittent error message.
Could somebody help in resolving this error.
BEA-380002: Indicates a connection error, such as the SOAP service not being reachable or available.
Some information is presented here: http://www.troubleshootingwiki.org/Handling_errors_in_SOA_based_systems
The error code are described here: http://download.oracle.com/docs/cd/E11036_01/alsb30/messages/alsb/kernel/l10n/TransportKernel.html
In case it helps - I'm writing a .Net 4 program that used the Oracle.DataAccess.dll as its data provider. To resolve another problem, we switched to using Oracle.ManagedDataAccess.dll. We immediately started getting the ORA-03111 when the program tried to open the connection. Switching back to the old .dll fixed the problem.