|
-
After the loop - yes, inside the loop - NO.
If you use WHERE CURRENT OF you had to open the cursor with the FOR UPDATE clause and this locks all rows selected by this cursor. COMMIT releases all locks and you get the error "fetch out of sequence" after subsequent fetch.
There was a bug up to 816 (I think) that prevented Oracle to report the error in this case so all seemed to be OK.
Ales
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote