title: PL/SQL compilation fails with no error message
body: <p>My installation of APEX has come pear shaped on a Oracle 9.2.0.5.0 instance, all the packages are invalid.</p>
  
  <p>I've tried recompiling everything with DBMS_UTILITY.compile_schema, but still all the packages are invalid. So, tried recompiling individual packages,</p>
  
  <pre><code>SQL&gt; ALTER PACKAGE FLOWS_020000.WWV_FLOW_QUERY COMPILE BODY;
  
  Warning: Package Body altered with compilation errors.
  
  SQL&gt; show err
  No errors.
  SQL&gt; 
  SQL&gt; ALTER PACKAGE FLOWS_020000.WWV_FLOW_QUERY COMPILE;
  
  Warning: Package altered with compilation errors.
  
  SQL&gt; show err
  No errors.
  SQL&gt; 
  </code></pre>
  
  <p>nothing in the alter log for it..</p>
  
  <p>How can I find what the error is? shouldn't "show err" give it to me?</p>