+ Reply to Thread
Results 1 to 3 of 3
  1. 02-02-2011 02:16 AM #1
    iris
    iris is offline Member
    Join Date
    Mar 2008
    Posts
    138

    compilation hangs

    The below query hangs, what could be the reason

    SQL> Alter procedure "procedure_name" compile;


    thanks,
    Reply With Quote Reply With Quote
  2. 02-02-2011 03:05 AM #2
    vnktummala's Avatar
    vnktummala
    vnktummala is offline Senior Advisor
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    861
    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.
    Reply With Quote Reply With Quote
  3. 02-02-2011 04:03 AM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    the procedure is probably locked - but a simple query against the database would have told you this
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width