RE: Package became INVALID

From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Sun, 27 Mar 2016 17:04:09 -0400
Message-ID: <004901d1886c$35bc8d90$a135a8b0$_at_gmail.com>

If any of the underlying objects get changed the package will go invalid and will need to recompiled. If when you try to compile it again, it compiles then there isn’t anything to worry about but if it has an error then you need address the error. One common scenarios is that tf the package has a truncate table command in it (using an execute immediate) and the package later accesses that objects the package body will become invalid every time it runs.    

Ken

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eriovaldo Andrietta Sent: Sunday, March 27, 2016 4:58 PM
To: ORACLE-L <oracle-l_at_freelists.org> Subject: Package became INVALID  

​Hello,  

I am in trouble with a package (note: this package uses a db_link in the code).

I created it, did

alter packave pck compile;

alter package pck compile body;​  

I check status it via :

select object_name, status, object_type from user_objects where status = 'INVALID';

The result of this query is : VALID for spec and body.  

After It, I don´t run anything and I check again and the package body became invalid.    

The package is compiled in the Oracle 12c (12.1.0.2.0)  

​Any idea ?

How can I see who is putting the package in the INVALID status ?  

Regards

Eriovaldo    

​  

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

Received on Sun Mar 27 2016 - 23:04:09 CEST