pros and cons of using stored procedures

Can anyone recommend a book, web page, etc. that explains the pros and cons of using stored procedures, as opposed to putting the code in your front-end code? The background info is that a group of us are designing a database and we'll be using Oracle, and for the front-end we'll be using a web interface probably with the PHP scripting language as the glue.

One of the people on the team is a proponent of using stored procedures and another is against it. Obviously, none of us are database experts and I'd like to be able to read up on stored procedures so that we can argue the issue intelligently.

Thanks Received on Fri Sep 07 2001 - 17:47:56 CDT