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

[vidya821]

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

[Anonymous · Accepted solution]

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

[vidya821]

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

[Anonymous]

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

[vidya821]

@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