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?
