Stored Procedures Considered Harmful (opens in new tab)

Agree with all of that. I worked somewhere that had a semi legit reason for using them: supporting Oracle and SQL Server. Stored procedures used to help reduce the knowledge the back end had of what type of DB it is talking to.