Re: Little help please

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Little-help-please-tp2606p2608.html

Hi Julie,

1)Why don't you directly update the rows? (rather than checking using select)
A row can be inserted in the time interval between your check and your update.

2)Your script is working with the seconds.
What will happen if your update will hang or will take some time to complete? Can you tolerate this? (I mean the business rules)

3)Why don't you do the time calculations in db? It sounds better because the real work is in db and the time calculation should be closer to the place where the work is done.. (this may supply a more guaranteed time-work coordination)