title: How to recompile invalid PLSQL packages that have been encrypted using Oracle 10g's Wrap utility?
body: <p>So I've taken an export (using Data Pump) from an Oracle 10g schema where all the PLSQL packages were encrypted using Oracle's <strong>Wrap</strong> utility. The problem is when I do an import of this into a new schema, all my packages are invalid, and trying a manual compile doesn't work. </p>
  
  <pre><code>SQL&gt; ALTER PACKAGE mypackage compile;
  
  Warning: Package altered with compilation errors.
  
  SQL&gt; show errors
  Errors for PACKAGE MYPACKAGE:
  
  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  36/2     PLS-00103: Encountered the symbol "2"
  </code></pre>
  
  <p>So what's the solution to recompiling all these invalid packages?</p>