Re: HELP: ORA-01410: invalid ROWID.

From: Prakash V <venkatprakash_at_hotmail.com>
Date: Fri, 03 Sep 1999 17:42:43 GMT
Message-ID: <19990903174244.44014.qmail@hotmail.com>

Yeah I had this problem. Whenever we are doing any update on a particular row, and at the same time if some other job is also trying to update something on the same row, then we will get this error.

For eg. u r deleteing a row from that talbe. At the same, while the transaction is going on, if you try to update the same row, then this time u will get the error.

An easy way to solve this problem, is row level locking,

Thanks

V Prakash

---

Get Your Private, Free Email at http://www.hotmail.com

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 12:42:43 CDT