Re: table locks in cursor. how it works?
Posted by:
Rick James
Date: October 01, 2012 07:42PM
The one notable mistake is having the FOR UPDATE outside the START...COMMIT transaction.
I don't see the need for a VIEW -- why not just construct the SELECT, then execute it?
With those two changes, you might not need the "locks" you asked about.
Subject
Views
Written By
Posted
6096
September 24, 2012 02:37AM
2373
September 28, 2012 01:35PM
2207
September 30, 2012 01:53PM
Re: table locks in cursor. how it works?
1692
October 01, 2012 07:42PM
1507
October 02, 2012 12:45AM
1475
October 02, 2012 08:33AM
1505
October 03, 2012 03:46PM
1327
October 03, 2012 11:26PM
1566
October 04, 2012 12:12AM
1337
October 04, 2012 08:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.