Originally posted by slimdave
Another excellent reason for the frontend to access the database using packaged procedures, instead of through direct SQL access.

Using packaged procedures that accept values to be bound to ref cursors gives you automatic protection against SQL injection.
Absolutely!

There are just sooooo many reasons to create a database abstraction layer out of procs/packages that I'm continually amazed at how few people actually do it.

- Chris