<p>I'm quoting part of an answer which I received for <a href="https://stackoverflow.com/questions/83088/phpmysql-regular-recalcuation-of-benchmark-values-as-new-users-submit-their-data">another question of mine</a>:</p>

<blockquote>
  <p>In the PHP/MySQL world I would say
  stored procedures are no-go</p>
</blockquote>

<p>I would like to know: Is that so? Why? Why not?</p>

<p>[edit]I mean this as a general question without a specific need in mind[/edit]</p>

Do you have a specific need in mind which makes you consider them? Stored procedures are much less portable than "plain" SQL, that's usually why people don't want to use them. Also, having written a fair share of PL/SQL, I must say that the procedural way of writing code adds complexity and it's just not very modern or testable. They might be handy in some special cases where you need to optimize, but I'd certainly think twice. Jeff has
similar opinions
.