title: How to show errors in sqlplus
body: <p>I would like to know how to show errors in sqlplus.</p>
  
  <ol>
  <li><p>try to compile a view</p>
  
  <p><code>alter view SYS.DBA_XML_SCHEMAS compile;</code></p></li>
  <li><p>I have the message :</p>
  
  <pre><code>ERROR at line 1:
  
  ORA-04063 : view altered with compilation errors.
  </code></pre></li>
  <li><p>I try :</p>
  
  <p><code>show errors;</code></p></li>
  <li><p>it says :</p>
  
  <pre><code>No errors
  </code></pre></li>
  <li><p>I try :</p>
  
  <pre><code>show errors view SYS.DBA_XML_SCHEMAS
  </code></pre></li>
  <li><p>it says :</p>
  
  <pre><code>LINE/COL  ERROR
  
  0/0       ORA-00942 : table or view does not exist
  </code></pre></li>
  </ol>
  
  <p>If I could compile with errors, the view must exist or it would tell me that the view does not exist. I dont know how to display the compilation errors of the view</p>
  
  <p>thank you</p>