Home » SQL & PL/SQL » SQL & PL/SQL » DEAD LOCK
DEAD LOCK [message #37371] Sun, 03 February 2002 18:46 Go to next message
Rajarshi
Messages: 11
Registered: November 2001
Junior Member
Say I have one table containing following fields:
CREATE TABLE TEST(
UIN NUMBER(10),
VALUE VARCHAR2(200));

I am submitting 2 update statements parallely... as
UPDATE TEST
SET VALUE = 'X'
where UIN between 100 and 200;
&
UPDATE TEST
SET VALUE = 'Y'
where UIN between 500 and 600;

Its giving me a following error:
ORA-00060 deadlock detected while waiting for resource

How to solve this problem?
Re: DEAD LOCK [message #37377 is a reply to message #37371] Mon, 04 February 2002 03:36 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
are u able to run those statements one at a time?.
Re: DEAD LOCK [message #37380 is a reply to message #37371] Mon, 04 February 2002 05:31 Go to previous message
Rajarshi
Messages: 11
Registered: November 2001
Junior Member
YES... I want to submit them simultaneously.... in 2 sessions !!
Previous Topic: queries
Next Topic: Urgent plzz Help!
Goto Forum:
  


Current Time: Thu Mar 28 13:54:21 CDT 2024