I have a dbadapter connect MS SQL Server 2017. My table define columns with datatype is nvarchar.
I have create store procedure get data from my table. But i excute it from BPEL i see error:
Exception occurred when binding was invoked.
Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'dbReference' failed due to: Unimplemented string conversion.
Conversion of JDBC type NVARCHAR to String is not supported.
An attempt was made to convert a Java object to String using an unsupported JDBC type: NVARCHAR.
Use a data type with a supported JDBC type.
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
- Oracle 12c (18.104.22.168.0)
- JDBC 7.0 from Microsoft.