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

# callWithParamsAwait

`suspend fun SQLOperations.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