thanks for you info
but how to find what are other sessions are locking this package?
Vladimir M. Zakharychev wrote:
> Shahnaz wrote:
> > Hi anybody,
> > I was getting error like below while compiling package
> > ORA-04021: timeout occurred while waiting to lock object start1.st
> > please assist me.
>
> This means that the object is currently in use and locked (some other
> session executes this stored procedure.) Wait until it finishes or kill
> that other session.
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Received on Wed Dec 06 2006 - 00:36:14 CST
