Re: Oracle error 4021

> I have been working a PL/SQL package, in the process of weeding
> out some bugs. Unfortunately I did not have the code set up to
> catch the situation where the program is in an infinite loop -
> there is no fall-back condition such as a counter value to stop the
> procedure if goes out of hand. Is there any way of "killing" (without
> having to ask the DBA) the process so that I recompile the package?
>
> The error message I get when attempting to compile the locked
> module is
>
> ORA-04021: time-out occurred while waiting to lock object name
>
> The way I see it, I should be able to kill my own job.

In the UNIX environment you can with "kill -9 process_number. On NT you are out of luck unless you have the OEM Instance Manager or a similar tool.

In the future you might want to consider inserting a counter variable into your loop or some code that checks for the presence of a specific value in another table (one you can easily update) during the initial testing phase.

Daniel A. Morgan Received on Fri Jun 25 1999 - 17:40:00 CDT