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,
Vijay Tummala 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
Forum Rules