<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>

try
```
```
SHOW ERRORS PACKAGE BODY FLOWS_020000.WWV_FLOW_QUERY
```
```