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:
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