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

Thread: PL/SQL hangs during the compilation

  1. 03-19-2003, 04:43 PM #1
    Blu
    Blu is offline Junior Member
    Join Date
    Apr 2002
    Posts
    73

    PL/SQL hangs during the compilation

    The PL/SQL hanges in one schema during the compilation, but it did compile fine for another schema, both schemas are in the same instance, we did analyze the two schemas nightly,any ideas?
    Reply With Quote Reply With Quote
  2. 03-20-2003, 03:02 AM #2
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    usually if compilation hangs, the (old, before-image) pl/sql-unit is locked due to hold by a session.
    Orca
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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