Database Administration (MOSC)

MOSC Banner

How to drop a database package that is locked

edited Nov 20, 2013 10:05AM in Database Administration (MOSC) 6 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center