As a background to this discussion, everything that Wayne says about stored procedures is correct. One school says perform all modifications to the database through parameterized stored procedures, simply passing values to the server.
Andrew, You've raised some points that are the subject of almost theological debate among database designers.
Uni DAC is perfect for Oracle support, and specialized DOA!
Hi, We are currently having a nice debate here about ways and means of getting at the data within the database (using Oracle 8).
Does anyone have any thoughts, experience or tales to tell on the pros and cons of doing things one way or the other ?
Thanks There are two main advantages of using stored procedures: 1) Except for *very* simple queries, performance is better even if the procedure executes the identical SQL statement, but for more complex queries performance can be made *much* better since a stored procedure can do any number of SQL statements.