Is there a way to use the built in DML Error Logging feature from within the tOracleOutput component? As far as I can tell you can only add hints, but nothing at the end of the insert statement.

To use this in a you add "LOG ERRORS INTO ..." at the end of the insert/update/merge/delete statement

Example:

INSERT INTO dw_empl
  SELECT employee_id, first_name, last_name, hire_date, salary, department_id
  FROM employees
  WHERE hire_date > sysdate - 7
  LOG ERRORS INTO err_empl ('daily_load') REJECT LIMIT 25


For more info oin this feature see the link:

http://docs.oracle.com/cd/E11882_01/server.112/e17120/tables004.htm#InsertDMLErrorLogging