[Amazon](500310) Invalid operation: Maximum number of stored procedures allowed exceeded

You might encounter the below message while creating a stored procedure in Amazon Redshift database.

Error : [Amazon](500310) Invalid operation: Maximum number of stored procedures allowed exceeded.

Amazon Redshift has a limit on the number of stored procedures you can create. It is currently set at 3000 per database.

Unfortunately, there is no workaround for the above error. You cannot create stored procedures beyond 3000.

See also  How to view the sql history(recent queries) of a user in Redshift