The issue of Form builder & SQL*Plus session getting hanged sounds intriguing. Does both sessions get hanged simultaneously? This form of locking is unheard of. What may be the probable cause?
Originally posted by stecal
I see this with Forms Builder. If I am connected to a database doing some Forms work, and someone else is connected via SQL*Plus trying to compile something or run a script, the SQL*Plus session will hang (not all the time). I have to disconnect from the 9i database or use a separate one for Forms work.