Unable to execute stored procedure (Redshift) using Redshift Execute

CALL get_result_set(1, ‘mycursor’);
FETCH ALL FROM mycursor;

Failure: SQL operation failed, Reason: A result was returned when none was expected., error code: 0, SQL state: 0100E, Resolution: Please check for valid Snap properties and input data.

Redshift stored procedure is not something that is supported today as part of the Redshift Snap Pack.
We have an enhancement request filed for this, for future consideration. It will be great if you could share additional information around your use case.