Re: table locks in cursor. how it works?
good morning
what do you mean under " notable mistake" ?
I cannot use just select, because query is built dynamically, and cursor cannot be openned on prepared statements. So, on forum I found 2 solutions - create view or temporary table. As view is aster and operates with real data I went with view.
situation requires granular update - row by row. It is not possible to make bulk update.
Subject
Views
Written By
Posted
5579
September 24, 2012 02:37AM
2153
September 28, 2012 01:35PM
2007
September 30, 2012 01:53PM
1524
October 01, 2012 07:42PM
Re: table locks in cursor. how it works?
1384
October 02, 2012 12:45AM
1341
October 02, 2012 08:33AM
1373
October 03, 2012 03:46PM
1190
October 03, 2012 11:26PM
1408
October 04, 2012 12:12AM
1191
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.