stored procedure recompile problem

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 trouble is, sometime (not always), when the stored procedure A is called, it never recompiles. It stays in status "INVALID" until some one explicitly reinstalled A from SQL-PLUS.

Anyone have anyidea about it, please let me know. I appreciate your help. Received on Mon Jul 28 1997 - 00:00:00 CDT