Package became INVALID

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sun, 27 Mar 2016 17:58:00 -0300
Message-ID: <CAJdDhaPY47Qnjn5N4kxarK43+KsDpGfNud2-XhF9g3qWkpEoBA_at_mail.gmail.com>



​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 - 22:58:00 CEST

Original text of this message