Re: package body invalidated

From: Gillian M <zmkj04_at_yahoo.com>
Date: Tue, 21 Nov 2000 15:26:38 -0800 (PST)
Message-Id: <10687.122671@fatcity.com>

The
dbms_utility.compile_schema('SCHEMA_NAME);

compiles the entire schema - objects compile in the sequence it suppose to.

G!
--- Nikunj Gupta <good_dba_at_hotmail.com> wrote: > RE: package body invalidatedHi,
>
> Are you using any views, procedures, packages,
> fuctions, synonyms etc ??
>
> Are there any snapshots ??
>
> If any of these are there.. just check.. do they get
> invalid too ??
>
> HTH
>
>
> ----- Original Message -----
> From: Alex Hillman
> To: Multiple recipients of list ORACLE-L
> Sent: Monday, November 20, 2000 11:26 AM
> Subject: RE: package body invalidated
>
>
> The package body does not have any errors. When I
> compile it it become valid again.
>
> Alex Hillman
>
> -----Original Message-----
> From: Ron Rogers [mailto:RROGERS_at_galottery.org]
> Sent: Monday, November 20, 2000 11:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: package body invalidated
>
>
>
> If you select * from dba_errors where name ='YOUR
> PACKAGE' you will get the errors and the line
> reference in the error.
> This will help in your trouble shooting the
> package.
> ROR mª¿ªm

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Tue Nov 21 2000 - 17:26:38 CST