I’m trying to call a stored procedure in Hyper SQL by using createSProcCall and execSProcCall. However, no result set is returned. The stored procedure works outside of Ignition though.
Hyper SQL uses a cursor to return a result set from the stored procedure. Are cursors not supported in Ignition when calling a stored procedure?