I'm not a big fan of stored procedures to encapsulate business logic. While you will certainly get better performance from putting the work in the database, your code is much less portable. For example, if you ever want to switch from Oracle to something else, it will be difficult.



With that said, Oracle's the kind of product that businesses don't migrate AWAY from. So, if you're planning on sticking with Oracle until the end of time (relatively speaking), it's not a big deal.