Stored procedures put logic into the database. A place where it's hard
to test, hard to version control, hard to access, and typically
written in a low-level language that's a pain to deal with. Every now
and then, you might find yourself in a situation where they're
actually worth it for performance reasons. Just like some times it
makes sense to write a piece of your application in C.
Treat stored procedures like C: Avoid it like the plague until it's
your only hope for survival.