Re: Lock Deleting

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 27 Jun 2005 10:48:34 +0200
Message-ID: <d9oeh2$24e$03$1@news.t-online.com>

Zephyr schrieb:
> Hi,
>
> my IDE has crashed while debugging a PL/SQL Procedure. After some fixes
> I want to replace the procedure now, but there is a lock on the provedure
> that prevent me from replacing
>
> ORA-04021: timeout occurred while waiting to lock object PRC_AUTOVAL
>
> How can I get rid of the lock?
>
> Thanks
> Patrick
>
>

Probably your old session executing that procedure is alive.You can try to find this session (by querieng v$access), kill it , after that you should be able to recompile or replace the procedure.

Best regards

Maxim Received on Mon Jun 27 2005 - 03:48:34 CDT