The below query hangs, what could be the reason

SQL> Alter procedure "procedure_name" compile;


thanks,