tOracleBulkExec NB_LINE_INSERTED

[BS0612]

Hello,

I am loading an Oracle Database with tOracleBulkExec. It works and the Database is loaded.

Now I trie to post the Global Variable NB_LINE_INSERTED using tJavaFlex and tLogRow connected with OnComponentOk.

System.out.println("NB_LINE_INSERTED: "+(globalMap.get((Integer)globalMap.get("tOracleBulkExec_1_NB_LINE_INSERTED"))));  

But I get :

NB_LINE_INSERTED: null

Does anyone have an idea what's wrong? Thanks!

[Jesperrekuh · Accepted solution]

NB LINE INSERTED. works with a row-counter , therefore when using a script it doesn't loop no iterator is increased... and inevitable NULL

They should implement SQL_MESSAGE which returns the response message by the server.
But they didn't

[TRF]

What if you connect the tJavaFlex with a OnSubjobOk trigger?

[BS0612]

Thanks, for the explaination.
What I don't understand is: Why is the global variable in the description of tOracleBulkExec offered, when this doesn't work?!

[brama]

Hi,

NB_LINE_INSERTED will work, but this has to be used post insertion to DB is completed. Check whether you are trying to print the value before it is set. Use OnComponent OK or OnSubJob ok, then print it, this will work.

Thanks,

Ramachandran B