Re: ORA-00060: deadlock detected while waiting for resource

From: mike <hillmw_at_charter.net>
Date: 13 Jul 2005 08:09:36 -0700
Message-ID: <1121267376.820348.183150@g43g2000cwa.googlegroups.com>

I have no idea what to do with this.

When I used: desc dbms_rowid using TOAD I got a package body window loaded and when pressed execute procedure I got a series of "set parameters" one of which was "rowid_info" defined below.

How do I use this to solve my problem: deadlocks

DECLARE
  ROWID_IN ROWID;
  ROWID_TYPE NUMBER;
  OBJECT_NUMBER NUMBER;
  RELATIVE_FNO NUMBER;
  BLOCK_NUMBER NUMBER;
  ROW_NUMBER NUMBER; BEGIN
  ROWID_IN := NULL;
  ROWID_TYPE := NULL;
  OBJECT_NUMBER := NULL;
  RELATIVE_FNO := NULL;
  BLOCK_NUMBER := NULL;
  ROW_NUMBER := NULL;   SYS.DBMS_ROWID.ROWID_INFO ( ROWID_IN, ROWID_TYPE, OBJECT_NUMBER, RELATIVE_FNO, BLOCK_NUMBER, ROW_NUMBER );   COMMIT;
END; Received on Wed Jul 13 2005 - 10:09:36 CDT