PDA

Click to See Complete Forum and Search --> : PL/SQL hangs during the compilation

Blu
03-19-2003, 03:43 PM
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?
Orca777
03-20-2003, 02:02 AM
Hi,
usually if compilation hangs, the (old, before-image) pl/sql-unit is locked due to hold by a session.
Orca
:cool: