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.