×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Oracle
Posted by: Maykel Vink
Added: Oct 2, 2012 1:59 PM
Modified: Oct 2, 2012 2:59 PM
Views: 28
Tags: oracle
http://www.oracle-base.com/articles/10g/dml-error-logging-10gr2.php
http://www.oracle-developer.net/display.php?id=329
  1. -- create error log as
  2. EXECUTE DBMS_ERRLOG.CREATE_ERROR_LOG('[TABLE_NAME]', '[ERROR_LOG_NAME]');
  3.  
  4. --INSERT STATEMENT
  5. INSERT INTO [TABLE_NAME] (a,b)
  6. (SELECT a,b FROM dual)
  7. LOG ERRORS INTO [ERROR_LOG_NAME] ('INSERT') REJECT LIMIT UNLIMITED;
  8.  
  9.  
  10.