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,
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-lReceived on Sun Mar 27 2016 - 22:58:00 CEST