2 Replies Latest reply: May 7, 2012 3:45 PM by 512902 RSS

    intermittent ORA-06508 (PL/SQL: could not find program unit being called)

    512902
      Encountering intermittent ORA-06508 (PL/SQL: could not find program unit being called) on function call

      Does anyone here have any idea why ORA-06508 intermittently happens?
      There aren't any invalid objects.

      Environment: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production (HPUX)

      Sample code: (fxn call from a fxn)
      Package01.function01
           bool_var boolean;
           …
           bool_var := Package02.function01(var1, var2, var3) --> This is where ORA-06508 happens
           …

      Package 02.function01(var1, var2, var3) returns boolean