Get the error message from oracle in tOracleOutput in to a context var
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. Thanks, Dave Figured this out: I can use tOracleOutput_1.ERROR_MESSAGE
