Parameters are not required for C and C++ procedure result sets
No parameter is required in the CREATE PROCEDURE statement signature for a procedure or in the associated procedure implementation in order to return a result set to the caller.
Result sets returned from C procedures, are returned using cursors.
For more on returning result sets from LANGUAGE C procedures, see: