i use oracle 8.1.5 on winNT.

When i try to compile all the packages of a particular
schema using dbms_utility.compile_schema procedure
i get the following error (please see the screen shot).

can anybody help to solve this?


SQL> exec dbms_utility.compile_schema('PHARM');
BEGIN dbms_utility.compile_schema('PHARM'); END;

*
ERROR at line 1:
ORA-01436: CONNECT BY loop in user data
ORA-06512: at "SYS.DBMS_UTILITY", line 195
ORA-06512: at line 1

SQL>


with thanks,
-Raja