When I get errors in my jobs, I save a row into an errors table in oracle. So for example, when I am outputting rows into my main oracle transaction table with tOracleOutput, I wish to do the following:
1. Capture the error returned from oracle into a context variable: context.OracleErrorMessage
2. 'Die on error' is checked in tOracleOutput - this works fine
3. Rollback - this works fine
4. then, use a tOracleRow to write out the error message into my error table tblETLErrors
I cannot figure out #1 above. It probably has something to do with tLogCatcher, or the first reject from the tOracleOutput, but not sure which is best, and how to best set this up.
Figured this out: I can use tOracleOutput_1.ERROR_MESSAGE