We have created a OSB business service based on DB procedure but it gave below error while testing. Please help.
Error:
The invocation resulted in an error: Invoke JCA outbound service failed with application 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/EmpowerServices/resources/WSDL/GetEmpowerAgentComplianceDetailsDB_WSDL [ GetEmpowerAgentComplianceDetails_ptt::GetEmpowerAgentComplianceDetails(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'GetEmpowerAgentComplianceDetails' failed due to: Unimplemented string conversion.
Conversion of JDBC type to String is not supported.
An attempt was made to convert a Java object to String using an unsupported JDBC type: .
; nested exception is:
BINDING.JCA-11804
Unimplemented string conversion.
Conversion of JDBC type to String is not supported.
An attempt was made to convert a Java object to String using an unsupported JDBC type: .
Use a data type with a supported JDBC type.