title: Oracle exception information
body: <p>I'm wondering if there is a way to get a little more information about what caused the exception:</p>
  
  <pre><code>Error starting at line 5 in command:
  exec ....
  Error report:
  ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at ..., line 558
  ORA-06512: at ..., line 752
  ORA-06512: at line 1
  06502. 00000 -  "PL/SQL: numeric or value error%s"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>I'm assuming this means I have a variable that is too small for what I tried to put in it... But why can't Oracle tell me what variable this is? It would be great for both debugging and production support people to be able to say to our client I think you have this field too big and that's what caused the error, rather than just "some value was too big and we really have no idea which one"... Using the line number would required someone who understood sql and looking at the code which is not ideal.</p>
  
  <p>Why is there nothing under the Cause and Action fields?</p>
  
  <p>When you try to insert into a col with data that is too large it tells you what col... I would like similar information here.</p>
  
  <p>Is that possible without having to put an exception handler after every plsql line of code?</p>