Stored Procedures Considered Harmful (pouyamiri.com)

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.