title: "ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure
body: <p>i m getting below error when i m trying to execute procedure "<code>PROCEDURE_NAME</code>" under procedure "<code>CALLING_PROCEDURE_NAME</code>".
  But my PROCEDURE_NAME is already in valid state and successfully using in some other procedures. </p>
  
  <pre><code>ORA-04068: existing state of packages has been discarded
  ORA-04065: not executed, altered or dropped stored procedure ""PROCEDURE_NAME""
  ORA-06508: PL/SQL: could not find program unit being called: ""PROCEDURE_NAME""
  ORA-06512: at ""CALLING_PROCEDURE_NAME"", line LINE_NO
  ORA-06512: at line 1
  </code></pre>