Package Compile Hangs
From: Walter Boggs <wboggs_at_wapa.gov>
Date: Thu, 22 Jul 1999 15:13:58 GMT
Message-ID: <7n7cfc$tqb$1_at_nnrp1.deja.com>
[Quoted] [Quoted] I'm trying to CREATE OR REPLACE a package on Oracle 7.1 via SQL*NT NT client. The declaration compiles fine, but when it gets to the body, the system hangs. There is no error, it just sits there.
Date: Thu, 22 Jul 1999 15:13:58 GMT
Message-ID: <7n7cfc$tqb$1_at_nnrp1.deja.com>
[Quoted] [Quoted] I'm trying to CREATE OR REPLACE a package on Oracle 7.1 via SQL*NT NT client. The declaration compiles fine, but when it gets to the body, the system hangs. There is no error, it just sits there.
If I click CANCEL, SQL*PLUS stops responding and I have to kill it. This leaves an Oracle session sitting out there with something locked, preventing me from even recompiling the old package. I can't kill the session, I assume because it has an operation in progress. The only way to get out of it is to bounce Oracle.
Does anyone have a clue what's going on? Thanks.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 22 1999 - 17:13:58 CEST