The below query hangs, what could be the reason
SQL> Alter procedure "procedure_name" compile;
from where you are running this query? directly in the DB server or from any third party?
trace the session and see what it is doing.
Try hard to get what you like OR you will be forced to like what you get.
the procedure is probably locked - but a simple query against the database would have told you this
Click Here to Expand Forum to Full Width