Why does for update in oracle 8 cause an ora-01002 error? : BEA Weblogic
- 1 Answers
- 1067 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shivram Meena
The ORA-01002 error is often caused by a row that cannot be locked due to concurrency issues. When using FOR UPDATE in Oracle 8, the session locks the rows until the transaction is committed or rolled back. If another session tries to access these locked rows before the original transaction is complete, it will encounter the ORA-01002 error.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
