Hi,

I am trying to call a stored procedure from ITX using JDBC adapter.

Stored procedure has 2 input parameters and 2 output parameters. How can we do that?

Also the first Input parameter is Number and the first out parameter is Number. How would I pass the number parameters?

I tried the command below but keep getting invalid column index sql exception below:

=GET("JDBC", "-URL DB -USER <id> -PASSWORD <pwd> -SCH <schema> -PROC <procedure> -TV  -QTY 1 -LSN 0 -AS 0",

ID + "|"  + TRIMRIGHT(xxx) + "|" + out1 + "|" + out2 + "<LF>")

<11804-17472-08/28/25 15:31:27>:     Preparing procedure call operation. Procedure: <procedurename>, schema: <schemaname>, catalog: null

<11804-17472-08/28/25 15:31:27>:     Generated procedure CALL statement: {call "<schemaname>"."<procedurename>"(?, ?)}

<11804-17472-08/28/25 15:31:27>:     Caught exception: com.hcl.hip.adapters.m4base.MBaseException

Error initializing source operation: java.sql.SQLException: Invalid column index

com.hcl.hip.adapters.m4base.MBaseException: Error initializing source operation: java.sql.SQLException: Invalid column index

Please share your thoughts on it.

Thanks

Santanu