procedure recompile question

In Oracle, whenever a stored procedure, say B, is recompiled, all the callers of the stored procedures are marked to be "INVALID". But normally it just means that when one of the callers ,say A, are executed, Oracle will recompile the code. If at that time the procedure A can go through the compiling ( this is normally TRUE if B is correct ), then the status of A should be back to "VALID".

My problem is, sometime (not always), when my application calls a stored procedure A, it never recompiles. It stays in status "INVALID" until some one explicitly reinstalled A from SQL-PLUS.

Any in which case a view can become invalid?

Any comments? Received on Tue Jul 29 1997 - 00:00:00 CDT