https://community.qlik.com/t5/Talend-Studio/Get-the-error-message-from-oracle-in-tOracleOutput-in-to-a/m-p/2362720#M126792 <P>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:<BR />1. Capture the error returned from oracle into a context variable: context.OracleErrorMessage<BR />2. 'Die on error' is checked in tOracleOutput - this works fine<BR />3. Rollback - this works fine<BR />4. then, use a tOracleRow to write out the error message into my error table tblETLErrors<BR />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.<BR />Thanks,<BR />Dave<BR />Figured this out: I can use tOracleOutput_1.ERROR_MESSAGE</P> Sat, 16 Nov 2024 13:40:50 GMT Anonymous 2024-11-16T13:40:50Z https://community.qlik.com/t5/Talend-Studio/Get-the-error-message-from-oracle-in-tOracleOutput-in-to-a/m-p/2362720#M126792 <P>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:<BR />1. Capture the error returned from oracle into a context variable: context.OracleErrorMessage<BR />2. 'Die on error' is checked in tOracleOutput - this works fine<BR />3. Rollback - this works fine<BR />4. then, use a tOracleRow to write out the error message into my error table tblETLErrors<BR />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.<BR />Thanks,<BR />Dave<BR />Figured this out: I can use tOracleOutput_1.ERROR_MESSAGE</P> Sat, 16 Nov 2024 13:40:50 GMT https://community.qlik.com/t5/Talend-Studio/Get-the-error-message-from-oracle-in-tOracleOutput-in-to-a/m-p/2362720#M126792 Anonymous 2024-11-16T13:40:50Z https://community.qlik.com/t5/Talend-Studio/Get-the-error-message-from-oracle-in-tOracleOutput-in-to-a/m-p/2362721#M126793 <P>Hi Dave,<BR />could you explain how do you do that?<BR />thanks<BR />tomás</P> Tue, 22 Jun 2010 11:29:40 GMT https://community.qlik.com/t5/Talend-Studio/Get-the-error-message-from-oracle-in-tOracleOutput-in-to-a/m-p/2362721#M126793 Anonymous 2010-06-22T11:29:40Z