DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: compilation hangs

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    compilation hangs

    The below query hangs, what could be the reason

    SQL> Alter procedure "procedure_name" compile;


    thanks,

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the procedure is probably locked - but a simple query against the database would have told you this

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width