Get the error message from oracle in tOracleOutput in to a context var

One Star

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

One Star

Re:Get the error message from oracle in tOracleOutput in to a context var

Hi Dave,
could you explain how do you do that?
thanks
tomás