Doa updatingtable salil and khushboo dating
-- Wayne Niddery - Win Wright Consulting RADBooks - You have a Right to Free Speech, but not the right to make me listen, nor to use my property as a soapbox. Whilst I accept that there are general benefits of using stored procedures, I see life being far easier for normal database updating using either a procedure that returns an updatable cursor or plain old SQL (I would like all the SQL to be centralised and not in the client however).Most tables require a screen to update them that is (90% of the time) simply a view of the table, with little bells or whistles.
This allows you to still use data aware controls etc..
All this adds up to *huge* performance improvements. Multiple applications, or one monolithic app broken into smaller pieces, all have access to these common server supplied procs.
Depending on the server (I don't personally know Oracle) there may be a security advantage as well - access only through the procedures means no-one can mess with the data through ad-hoc queries.
I have taken the pkgapply demo a little further to do a refresh immediately upon editing and also to do optimistic locking (both simple when I read the help pages).
As I said all of this does require a lot more code than simple SQL based queries that are updatable, I just need to weigh the advantages of what would be effectively an API for our application over speed of development.You seem to me to be thinking along the right lines.