Hi All,
I am trying to create a JDBC adapter with StoredProcedureWithSignature, which has the below connection properties:
|Transaction Type|NO_TRANSACTION|
|DataSource Class|com.microsoft.sqlserver.jdbc.SQLServerDataSource|
The cursor parameters are getting loaded as INT as sql data type and JDBC data type instead of CURSOR:
Also, it is expecting the cursor as an input too. In Stored procedure, the data type of the cursors is given as CURSOR VARYING OUTPUTS.
How can i get cursor data type in my adapter and also as only output param. Can anyone please help on this?
wM version: 10.11
JDBC version: 10.3
JDBC fix: Fix 10
Thanks in advance.