title: How to create error log for stored procedure in oracle 10g?
body: <p>I need an example of creating error log file for stored procedure in oracle.
  please give me an example with table creation and stored procedure creation and error log creation.</p>
  
  <p>Thanks in advance</p>
  
  <p><strong>EDIT</strong> (relevant info from other question)</p>
  
  <p>Suppose there is a stored procedure. When I am executing that stored procedure, some expected error/exception may occur, so I need to create an error log table in which all the errors will automatically be store whenever I will execute the stored procedure.</p>
  
  <p>For example, if there is some column which does not allow null values, but the user is entering null values, then that error should be generated and it should stored in the error log table.</p>