compilation hangs

[iris]

The below query hangs, what could be the reason

SQL> Alter procedure "procedure_name" compile;


thanks,

[vnktummala]

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.

Thanks,

[davey23uk]

the procedure is probably locked - but a simple query against the database would have told you this