MySQL Stored Procedure Programming

What do you guys think about stored procedure programming? Any of you have any experience with this?

Should I look further into this?