Re: URGENT: Package keeps going invalid

From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Mon, 2 Jul 2007 11:20:49 -0400
Message-ID: <9c9b9dc90707020820u6beb98car5874d8b3fd90c2b0@mail.gmail.com>

Paula,

One way to figure this out is to look at DBA_OBJECTS and check LAST_DDL dates of other objects (those of interest will be referenced by your package) that went invalid at the same time. A trigger can be used to log this information into a tracking table for complete after the fact analysis. Something you should watch is the granting of privileges as that can cause an invalidation/revalidation sequence.

On 7/2/07, Paula Stankus <paulastankus_at_yahoo.com> wrote:
>
> We are running Oracle Version 8.1.7.4 on Solaris 2.9
>
> We have a package that keeps going invalid. It uses oracle mail with
> utl_smtp. We also have been having mail server problems.
>
> 1-Could a problem with mail services be causes a problem with a
> user-defined package using utl_smtp and those mail services?
>
> 2-What is the most efficient way to track WHAT made a package go invalid?
>
> Thanks,
> Paula
>
> ------------------------------
> Park yourself in front of a world of choices in alternative vehicles.
> Visit the Yahoo! Auto Green Center.<http://us.rd.yahoo.com/evt=48246/*http://autos.yahoo.com/green_center/;_ylc=X3oDMTE5cDF2bXZzBF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW4tY2VudGVy>
>
>

-- 
Rumpi Gravenstein

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 02 2007 - 10:20:49 CDT