Cannot compile a simple oracle procedure...it's in one database and connected to another via dblink...error is
PLS-00907: cannot load library unit SYS.SYS_STUB_FOR_PURITY_ANALYSIS@NLDB_REMOTE_CONNECT.NL.EDU
(referenced by BANINST1.F_STUDENT_GET_DESC@NLDB_REMOTE_CONNECT.NL.EDU)
the dblink user HAS execute privs on the sys.sys_stub_for_purity_analysis package!!
Many OTHER load procedures in the same schema using the same dblink...DO compile...any thoughts?