[iracic]

There is. When you need to treat your data without network delays. When performance is essential. When you can't express it efficiently with non-procedural SQL or need to have access with several technologies (can think of it as service on db level). Depending of environments, deploying changes can be much easier than patching app side.

[tcbasche]

That is a very good point :) I definitely did not consider the performance benefits. You learn something new every day!