Forum Discussion

dgupta's avatar
dgupta
New Contributor
7 years ago

Unable to execute stored procedure (Redshift) using Redshift Execute

SQL:
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

2 Replies

  • dgupta's avatar
    dgupta
    New Contributor
    6 years ago

    Hi there,

    Until the enhancement is ready , is there any workaround to execute a Redshift stored procedure that returns a result set.

    Thanks

  • sriram's avatar
    sriram
    Former Employee
    7 years ago

    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.