How to drop a database package that is locked
Hi,I have created a database package which included a procedure having an infinite loop.
When I submitted the package procedure (from Linux server) my SQL*plus session hanged and eventually I had to exit by pressing Control-Backslash.
Thereafter I am not able to drop or resubmit the package procedure.
I am a developer and lack DBA access though I am able to query most v$ views.
Is there any script available that will enable me to identify the session or the lock and kill it.
Thanks
When I submitted the package procedure (from Linux server) my SQL*plus session hanged and eventually I had to exit by pressing Control-Backslash.
Thereafter I am not able to drop or resubmit the package procedure.
I am a developer and lack DBA access though I am able to query most v$ views.
Is there any script available that will enable me to identify the session or the lock and kill it.
Thanks
0