Invalid Object

E

espana

Member
Hi , need some help from all the expert here. I am using PLSQL Developer V6 and Oracles 8i.

We face this problem very occassionally is that without doing anything, Valid prcedure and packages becoming invalid object when compiling using the PLSQL. This cause our program to fail and need to recompile again. The worst part is that we need to monitor so closely whether any failure or invalid object occur or not.

Anyone face the same problem? Any advice is definitely welcome
 
This problem happens, at least in our experience, when both the package body and spec are compiled. Any packages that rely on the just compiled package go invalid.

So, if your package spec does not change, do not compile it.
 
My case is abit special. The problem is that when we open up the PL SQL Developer the next day. It just go invalid. We did not do any recompiling.

Any idea on this?
 
Btw the pl sql developer does not show any invalid object. But when running the job, it the oracle error appear and say that there is invalid object.
 
Things can only become invalid when they are altered, or when a referenced object is altered. Running a job should never invalidate anything.
 
You must log in or register to reply here.
Back
Top