DEV Community

loading...

Discussion on: When is it a good idea to use stored procedures?

Collapse
scottishross profile image
Ross Henderson

I use them all the time to be honest. If I don't want the code visible, I'll call them from a package. We do everything we can to keep the logic out of the application code, if it isn't tiny or very specific to that application.

Use the utility when needed. There's no point limiting yourself for the 1 in 100 cases using something else might be better.