title: Show errors in sql plus
body: <p>I have a file <code>myFile.sql</code> that contains a list of script to compile :</p>
  
  <pre><code>@"Directory\package1.sql"
  @"Directory\package2.sql"
  @"Directory\package3.sql"
  @"Directory\package4.sql"
  </code></pre>
  
  <p>I have the following script:</p>
  
  <pre><code>SPOOL Directory\Upgrade.log
  @"Directory\myFile.sql"
  SPOOL OFF
  </code></pre>
  
  <p>Some packages in <code>myFile.sql</code> have errors, but in <code>Upgrade.log</code> I do not have the details of the errors, I have the message Warning : <code>Package body created with compilation errors.</code>
  How can I add the error detail without adding SHOW ERR after each line in <code>MyFile.sql</code> ?
  In upgrade.log I want have this:</p>
  
  <pre><code>Package1 created
  Warning Package body created with compilation errors.
  **Error detail1**
  
  Package2 created
  Warning Package body created with compilation errors.
  **Error detail2**
  </code></pre>
  
  <p>I need a hook in <strong>sqlplus</strong> to show error <strong>automatically</strong> after each package creation if there is an error
  Thanks for your help.</p>