Hi, David, how about killing the session that locks the procedure?
(with V$SESSION, V$LOCKED_OBJECT, DBA_OBJECTS tables)
HTH.

Regards

James

> I have a stored procedure that I'd like to drop. Using TOAD, whenever I try
> to drop it, I get ORA-04021 - timeout occurred while waiting to lock
> object.
>
> I understand what the error message means, but how do I remove any locks on
> that object, or override them and drop the object by brute force?
>
> Thanks in advance!
>
> --------

Oracle LazyDBA home page