Oracle stored procedures vs Running from a flat .sql file

Does anyone know what the advantages are to using stored procedures and java stored procedures over and above running from flat unix files.

I find that since our application is all stored in the database it is harder to understand when something goes wrong with it. The traditional way to running a job stream is to have a unix script with steps in it. The way this application is set up is to run everything as one long call from a stored procedure.

Anyone have experiences with this? The develepers have gone as far as reading and writing files using the UTIL_FILE package instead of doing this with a ksh. This has caused a great deal of effort for debugging at the unix level because they can't even tell me (as the Unix System admin) if there is a permission problem with the files it tries to access when the application fails.. It's all guess work to fix something.. Received on Sat Jan 04 2003 - 09:08:45 CST