Oracle Error Message
PLS-00738: REF target string changed during compilation
Reason for the Error
The current unit contains a REF to a target object. During compilation, the REF’s target object was simultaneously changed by a different session. The current unit is therefore invalid and needs to be recompiled to pick up the latest definition of the REF target.
Solution
Recompile the unit that has this error.