vertx / io.vertx.kotlin.ext.sql / io.vertx.ext.sql.SQLConnection / callWithParamsAwait

callWithParamsAwait

suspend fun SQLConnection.callWithParamsAwait(sql: String, params: JsonArray, outputs: JsonArray): ResultSet

Calls the given SQL PROCEDURE which returns the result from the procedure.

The index of params and outputs are important for both arrays, for example when dealing with a prodecure that takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:

Parameters

sql - the SQL to execute. For example {call getEmpName (?, ?)}.

params - these are the parameters to fill the statement.

outputs - these are the outputs to fill the statement.

resultHandler - the handler which is called once the operation completes. It will return a ResultSet.

Return