procedure involving dblinks gets invalidated regularly .we need to recompile every time.How to find what is causing the problem
in my case
procedure p1()--resides in db1 is begin .... select col1 from table1@db2; ... end /
for some reasons the procedure gets invalidated and the dblinks doesnt work and i get the following errors
ORA-04052 ORA-00604 ORA-02019
and i recompile all the invalid objects this seem to work.
i need to figure why the proc in db1 gets invalidated?