Reactive Oracle Stored Procedure Cursor Out Parameter

[AmgadHassanNabil]

Hi Everyone,

I need to call an Oracle stored procedure with a cursor as an out parameter. Here is the code I came up with so far.

`
@Inject
OraclePool client;

@GET
public Multi<Transaction> operation() {
    JsonArray out = new JsonArray().add(OracleTypes.CURSOR);
    Multi<Transaction> transactions = this.client.preparedQuery("{call INSERT_USER(?,?,?)}")
            .execute(Tuple.of("Amgad", 1234, out)).onItem()
            .transformToMulti(set -> Multi.createFrom().iterable(set))
            .onItem().transform(Transaction::from);

    return transactions;
}`

But I get the below error.

java.sql.SQLException: Invalid column type\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8783)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8265)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9040)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9015)\r\n\tat oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:222)\r\n\tat io.vertx.oracleclient.impl.commands.OraclePreparedQuery.fillStatement(OraclePreparedQuery.java:63)\r\n\tat io.vertx.oracleclient.impl.commands.QueryCommand.lambda$prepare$2(QueryCommand.java:112)\r\n\tat io.vertx.core.impl.ContextBase.lambda$null$0(ContextBase.java:137)\r\n\tat io.vertx.core.impl.ContextInternal.dispatch(ContextInternal.java:264)\r\n\tat io.vertx.core.impl.ContextBase.lambda$executeBlocking$1(ContextBase.java:135)\r\n\tat org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)\r\n\tat org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2449)\r\n\tat org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1478)\r\n\tat org.jboss.threads.DelegatingRunnable.run(DelegatingRunnable.java:29)\r\n\tat org.jboss.threads.ThreadLocalResettingRunnable.run(ThreadLocalResettingRunnable.java:29)\r\n\tat io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)\r\n\tat java.base/java.lang.Thread.run(Thread.java:833)
I searched the internet a lot for this issue but couldn't find a solution.