ORA-04052: error occurred when looking up remote object SYS.X$JOXSCD@FG02.FGIC.COM
After upgrading a database to 11g (11.2.0.4), I get the below error when accessing DBA_SOURCE in that database over a DB link. And it only happens in PL/SQL and not direct SQL. Also, it seems it is only an issue with DBA_SOURCE. I have a package where this error occurs, and that package queries many of the DBA views through this DB link. But I narrowed it down to DBA_SOURCE. When the one query to DBA_SOURCE@FG02 is in the package, it won't compile. When I take it out, the package compiles. So all the other queries of other DBA views