Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Strange behavior when compiling one package, it invalidates other...

746586May 11 2011 — edited May 19 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2011
Added on May 11 2011
8 comments
627 views