The below query hangs, what could be the reason
SQL> Alter procedure "procedure_name" compile;
thanks,
Printable View
The below query hangs, what could be the reason
SQL> Alter procedure "procedure_name" compile;
thanks,
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,
the procedure is probably locked - but a simple query against the database would have told you this