title: Is there a way to get the line number where an exception was thrown?
body: <p>Im working on a pl-sql script, in which I have about 10 TO_CHAR conversions.</p>
  
  <p>One of them is throwing an </p>
  
  <pre><code>ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  </code></pre>
  
  <p>exception.</p>
  
  <p>Currently, im logging the message with this piece of code</p>
  
  <pre><code>EXCEPTION
    WHEN OTHERS THEN
      DBMS_OUTPUT.put_line('Exception message is '||SQLERRM(sqlcode));
      ROLLBACK;
  </code></pre>
  
  <p>I'd like to add (mostly for debugging purposes) the line where the exception is thrown, in order to receive a message in the form of</p>
  
  <pre><code>ORA-06502: PL/SQL: numeric or value error: character string buffer too small (at line x)
  </code></pre>
  
  <p>Is there an easy way to do this?</p>