PL/SQL developer (allroundautomations.com) hangs while compiling Package Body

Question

i am using PL/SQL developer by allroundautomations. Some days back i was able to create package and package body. i did recompiled several times package body. But since yesterday, i am facing this issue. I open package body and click on recompile (without doing any changes) it hangs.

please help !!!

score 2 · Accepted Answer · answered Dec 04 '14 at 05:25

2

Perhaps you could wait for a while until you see ORA-04021 timeout occurred while waiting to lock object. Even if you close the PL/SQL Developer window or end the process, the previous session might still be ACTIVE. You can kill that session and try again.

You can query v$locked_object to find out.

It is also possible that, the package is in use by some other session when you try to compile it.

You can query v$sqlarea and v$session to find out.

answered Dec 04 '14 at 05:25

Lalit Kumar B

47,486
13
97
124

i get "timeout occured while waiting to lock objects" this error after long time. – Sam4Code Dec 04 '14 at 05:55
i tried to query v$locked_object table but it says table of view does not exist – Sam4Code Dec 04 '14 at 05:57
It means you do not have the privilege to access v$locked_object. – Lalit Kumar B Dec 04 '14 at 07:01
Thanks Lalit. I need to check with administrator to resolve this issue. Thanks for your quick response. – Sam4Code Dec 04 '14 at 11:17

PL/SQL developer (allroundautomations.com) hangs while compiling Package Body

1 Answers1