tOracleRow error

[Anonymous]

tOracleRow java.lang.NullPointerException
I am facing the above exception when I am trying to execute the following job:
tFileInputJSON----tFlowToIterate-----tOracleRow
with the sql query---->"update employee_combine set email_new = "+((String)globalMap.get("email"))+" where id<=50"
I am retrieving the email from JSON file and inserting into an existing oracle table.
I understand that null values are being passed, and hence the database is giving the exception.
Can anyone suggest what changes I could make so that the flow works.

[Anonymous]

Hi 
Assuming the job design looks like
tFileInputJSON--row1(main)--tFlowToIterate---iterate--tOracleRow


The correct syntax should be:

"update employee_combine set email_new = "+((String)globalMap.get("row1.email"))+" where id<=50"

Regards
Shong

[Anonymous]

It is still throwing the same exception!

[Anonymous]

Hi 
Can you upload a screenshot of your job and show us the query used on tOracleRow?

Regards
Shong