-
error in using dbms_utility.compile_schema
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|