Re: ora04021:timeout occurred while waiting to lock object

leonardo_sheryl_at_yahoo.com wrote:
> hi every one.
>
> pls help
>
> i am getting this error while compiling pacakage body in a debug mode
> from toad, its prompt me after every 12min and ask me whether i should
> continue or ignore all.
> i am using this pacakage REGIONAL.PKG_CWR
>
> ora04021:timeout occurred while waiting to lock object ...
>
>
> after pressing continue, the last message is
>
> "the following error has occurred:
>
> ORA-04021: timeout occurred while waiting to lock object
> REGIONAL.PKG_CWR"
>
> i want to debug this pacakage through toad, what should i do?

Kick everyone off the system who is using it.

Same answer you got on the OTN forum.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org