Home » SQL & PL/SQL » SQL & PL/SQL » Locking when update record
Locking when update record [message #38097] Wed, 20 March 2002 05:28 Go to next message
Stupid
Messages: 8
Registered: November 2001
Junior Member
Dear all,

Am I need to use "SELECT FOR UPDATE" to lock the
record in the package before I "UPDATE ....SET ...." the record ??
Thanks !!!
Re: Locking when update record [message #38104 is a reply to message #38097] Wed, 20 March 2002 17:21 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
Both of statement will lock the record. you need to consider the locking on program and business logic, whether this locking will cause enquery to other operation in your environment. Hoep this is helping.
Previous Topic: loop error
Next Topic: Is it possible to view stored procedures/ Functions that i had created in the next futher login sess
Goto Forum:
  


Current Time: Thu Mar 28 17:04:52 CDT 2024