Re: 8.1.7 + Designer 6.0 --> A bug ?

From: Stefan Moeding <s.moeding_at_ndh.net>
Date: 05 Mar 2001 22:49:47 +0100
Message-ID: <87k8636g3o.fsf@esprit.firekeys.org>

Hi!

Walter Pircali writes:

> we have an Win2kServer SP1 with an 8.1.7 over it and 3 instances.
> We use one of this instance for Oracle Designer 6.0.
> As soon as we try to create the oracle designer repository it starts
> to make all, and then on package CIOUELEMENT_TYPE it hangs (CPU 100%).

You might be hitting bug# 1396675.

Designer uses the following type of statement, which will hang (or eventually bomb out with ORA-4031) on 8.1.7:

SQL> create table foo (a number, b number); SQL> create procedure baz as
  2 begin
  3 delete from foo
  4 where (a,b) in ((1,1), (2,2), (3,3), (4,4));   5 end;
  6 /

-- 
Stefan

Received on Mon Mar 05 2001 - 15:49:47 CST