Board index » delphi » Any thoughts on procedurised DB access
a...@defsdoor.demon.co.uk (Andrew Porter)
Wed, 18 Jun 1902 08:00:00 GMT
Any thoughts on procedurised DB access
We are currently having a nice debate here about ways and means of
getting at the data within the database (using Oracle 8). One camp is
arguing that we should not be using SQL but calling procedures to add,
amend and delete records, the other camp (Ok me :) ) is wondering is
this is worthwhile as this is the job that SQL was designed to do in
the first place.
I have some concerns over the disjointedness of using procedures to
amend the tables - I see it being far too much work even to implement
I favour using Direct Oracle Access Components with either SQL stored
in the server and cached in the client, or PL/SQL procedures that
return cursors that DOA can manipulate. I see the DOA components
doing all of the hard work then and I don't have to worry about it.
Does anyone have any thoughts, experience or tales to tell on the pros
and cons of doing things one way or the other ?