topic Re: tOracleOutputBulkExec - how to use the Advanced Setting "Output" To Global Variable in Talend Studio

tOracleOutputBulkExec - how to use the Advanced Setting "Output" To Global Variable

vidya821 — Sat, 16 Nov 2024 05:59:39 GMT

Hi All,

Can someone pls tell me whats and how to use the Output - To Global Variable in the tOracleOutputBulkExec component ?

will this output contains the no of records inserted in the DB and if so how can i retreive this value ?

Thanks

Re: tOracleOutputBulkExec - how to use the Advanced Setting "Output" To Global Variable

Anonymous — Fri, 26 Apr 2019 06:36:32 GMT

Hello,

When you use a tOracleOutputBulkExec component, you only see the ERROR_MESSAGE

globalMap option. To display the global variables, configure the tJava component using the following statements.

System.out.println("Return Code: " + globalMap.get("tOracleOutputBulkExec_1_tOBE_RETURN_CODE"));
System.out.println("Number of line data: " + globalMap.get("tOracleOutputBulkExec_1_tOBE_NB_LINE_DATA"));
System.out.println("Number of bad line: " + globalMap.get("tOracleOutputBulkExec_1_tOBE_NB_LINE_BAD"));
System.out.println("Number of inserted line: " + globalMap.get("tOracleOutputBulkExec_1_tOBE_NB_LINE_INSERTED"));

Let us know if it works for you.

Best regards

Sabrina

Re: tOracleOutputBulkExec - how to use the Advanced Setting "Output" To Global Variable

vidya821 — Fri, 26 Apr 2019 06:47:31 GMT

It does work..but instead of tOracle it shud be tDB
System.out.println("Number of inserted line: " + globalMap.get("tDBOutputBulkExec_1_tOBE_NB_LINE_INSERTED"));
Thanks

Re: tOracleOutputBulkExec - how to use the Advanced Setting "Output" To Global Variable

Anonymous — Fri, 26 Apr 2019 06:50:17 GMT

Hello,

@vidya821 wrote:
It does work..but instead of tOracle it shud be tDB
System.out.println("Number of inserted line: " + globalMap.get("tDBOutputBulkExec_1_tOBE_NB_LINE_INSERTED"));
Thanks

Great it works. Thanks for your correct.

Best regards

Sabrina

Re: tOracleOutputBulkExec - how to use the Advanced Setting "Output" To Global Variable

vidya821 — Wed, 22 May 2019 11:33:02 GMT

@xdshi, Facing a new issue, the variable works fine when we run the job in studio however when we execute the same via TAC then it fetches null value.

Any idea or leads ?

Thanks