cvsubbarao
Programmer
I want some information regarding begin transaction and end transaction.
suppose I have a table called orders. I want to update some records in that table with in the begin transaction and end transaction like this
begin transaction
update orders set status = 'ia' where status = 'na'
end transaction
my problem is, if any of the record participates in the above transaction is previously locked by another user then what is the status of my transaction.
Is it wait to release all locks for all records before it commits the transaction or gives the error message?
suppose I have a table called orders. I want to update some records in that table with in the begin transaction and end transaction like this
begin transaction
update orders set status = 'ia' where status = 'na'
end transaction
my problem is, if any of the record participates in the above transaction is previously locked by another user then what is the status of my transaction.
Is it wait to release all locks for all records before it commits the transaction or gives the error message?