So apparently supporting this is going to be HIGHLY dialect specific. As far as I can tell, only Oracle and PostgreSQL really have support for REF_CURSOR.

Unless I miss something, for PostgreSQL returning a cursor means:

1. The "procedure" will have to be a function.
2. There can be only one such REF_CURSOR parameter and it needs to be first
3. When creating the CallableStatement, we need to use the {?=call functionName(...)} form

For Oracle, returning cursors is supported both via function return value and via parameters, meaning:

1. We could have a function or a procedure.
2. There might be multiple REF_CURSOR parameters and they could occur in any order/postion
3. When creating the CallableStatement, we actually have no clue whether we need the {call procedureName(...)}

   form or the {?=call functionName(...)} form