Bug? 8i on W2000

From: Hakan Eren <heren_at_home.com>
Date: 2000/06/21
Message-ID: <395012F4.748B80C7@home.com>#1/1

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 Wed Jun 21 2000 - 00:00:00 CDT