Re: Bug? 8i on W2000

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 2000/06/20
Message-ID: <39503D57.469795D5@ntsource.com>#1/1

One can get the same suspicious results with a simpler query:

SQL> select * from sys.order_object_by_dependency; select * from sys.order_object_by_dependency

                  *

ERROR at line 1:
ORA-01436: CONNECT BY loop in user data

using Oracle 8.1.6 on NT.

The connect by is in the text of the order_object_by_dependency view which can be obtained from the dba_views view.

Frank Hubeny

Hakan Eren wrote:

> Hi,
>
> The following query
>
> SELECT DECODE(object_type, 'PACKAGE BODY', 'ALTER PACKAGE ' || owner ||
> '.' || object_name || ' COMPILE BODY',
> 'ALTER ' || object_type || ' ' || owner || '.' || object_name || '
> COMPILE') stmt
> FROM dba_objects a, sys.order_object_by_dependency b
> WHERE a.object_id = b.object_id (+)
> AND status = 'INVALID'
> AND object_type IN ('PACKAGE BODY','PACKAGE','FUNCTION','PROCEDURE',
> 'TRIGGER','VIEW')
> ORDER BY dlevel DESC, object_type, object_name
>
> returns the following on Oracle 8i on W2000. It works fine on Oracle7.
>
> STMT
> --------------------------------------------------------------------------------
> ORA-01436: CONNECT BY loop in user data
>
> Any ideas?
>
> Thanks
>
> Hakan
Received on Tue Jun 20 2000 - 00:00:00 CDT