Re: Package Compile Hangs

We had a similar problem that seemed to be caused by a long-running query in a procedure that included dynamic SQL. The only cure seemed to be to improve the efficiency of the query. Some locking problem seemed to be occurring that hung processes and prevented re-compiling the package containing the procedure, until Oracle was re-started.

Walter Boggs <wboggs_at_wapa.gov> wrote in message news:7n7cfc$tqb$1_at_nnrp1.deja.com...
> 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 - 18:09:27 CEST