title: ORA-04068: existing state of packages has been discarded
body: <p>I've wrapper procedure which looks like this:</p>
  
  <pre><code>Procedure A
  BEGIN;
      Procedure B
      Procedure C
  END;
  /
  </code></pre>
  
  <p>Procedure B drops and re-creates a table used in Procedure C. Due to this, I get the below error:</p>
  
  <pre><code>ERROR at line 1: 
  ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "SCHEMA.PROCEDURE C" 
  ORA-06508: PL/SQL: could not find program unit being called: "SCHEMA.PROCEDURE C" 
  ORA-06512: at "SCHEMA.PROCEDURE A", line 4 
  ORA-06512: at line 1
  </code></pre>
  
  <p>How do I go about getting this procedure to work?</p>