Re: Package Error After New NT Installation

i've never gotten the 1436 error when compiling packages, but then again, i've not used 8.1.6 on NT either. there may be a few scripts that did not execute when you created the database, like catproc.sql, catrep.sql, et.al. running one or more of these scripts may resolve the problem for you.

i'm not exacatly sure what the 'compile all' in TOAD does, but with all of the dependencies between the packages, a compile of one package specification will probably invalidate other packages, which then have to be compiled, and on and on...

you may be able to compile just the package body (rather than both the package and package body) of the invalid packages.

you can generate a list of the invalid objects by running a query on dba_objects. here's a sample query (this is from memory, and hasn't been tested, so it might need a tweak) that generates a list of statements to execute:

select 'alter '||owner||'.'||object_name||' compile package body;'   from dba_objects
 where owner = 'SYS'
   and object_type = 'PACKAGE BODY'
   and status = 'INVALID'

you can then run the generated commands, and then rerun the query to see if there are any other invalid package bodies. to check for invalid package specifications, you can use a similar query:

select 'alter '||owner||'.'||object_name||' compile package;'   from dba_objects
 where owner = 'SYS'
   and object_type = 'PACKAGE'
   and status = 'INVALID'

HTH "Eric Parker" <ericparker39_at_hotmail.com> wrote in message news:39CA3409.341FE8B1_at_hotmail.com...
> After downloading the 8.1.6 R2 Enterprise Edition & installing it on an
> NT4 with SP5. I found the some of the packages in the SYS schema needed
> recompilation. Through TOAD as SYS I invoked the 'compile all' option
> which returned the following error :
>
> ORA-01436: CONNECT BY loop in user data
> ORA-06512: at "SYS.DBMS_UTILITY", line 195
> ORA-06512: at line 1
>
> Any clues anybody ?
>
> Thanks
>
> eric
>
>
Received on Thu Sep 21 2000 - 00:00:00 CDT