Hello,
for many hours trying, I'm not able to figure how is it possible. We create a schema on any database and it works perfectly, but it has some problems in only one particular instance.
When we compile one invalid package, it works perfectly but it has the effect of invalidate other already valid packages and dependent objects (like a trigger).
Any idea of this fuzzy behavior?
See this sample script:
SQL> select object_name, object_type, status
from user_objects
where status <> 'VALID'
OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------------------------------------------------------------------------------------- ------------------- -------
ENA_SECURITE PACKAGE BODY INVALID
1 row selected.
SQL> alter package ena_securite compile
Package altered.
SQL> select *
from user_errors
no rows selected.
SQL> select object_name, object_type, status
from user_objects
where status <> 'VALID'
OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------------------------------------------------------------------------------------- ------------------- -------
ENA PACKAGE BODY INVALID
ENA_SITE_COURS PACKAGE BODY INVALID
SECO_PIR TRIGGER INVALID
3 rows selected.
Info on our database:
SQL> select * from v$version
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
5 rows selected.
thanks,
Bruno