View Single Post

   
  #8 (permalink)  
Old 04-08-2008, 08:11 AM
mike
 
Posts: n/a
Default Re: ORA-00060: deadlock detected while waiting for resource

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;

Reply With Quote