Page 1 of 1
Posted: Fri Jun 12, 2015 2:42 am
by ray.wurlod
Welcome aboard.
What are the NLS settings for this stage/job?
Posted: Fri Jun 12, 2015 3:22 pm
by ravigoud87
Hi,
1) we upgrdaed DS from 7.5 to 11.3
2) That job is a SERVER JOB in DS 7.5 and even in 11.3 its a SERVER JOB
3) we are connecting to ORACLE ( Inbound) using ODBC
4) NLS Settings - "Project default (UFT8)"
Posted: Fri Jun 12, 2015 5:35 pm
by chulett
Why is your Job Type set to Parallel? I'm going to fix that in your first post and move this to the proper forum.
Posted: Mon Jun 15, 2015 11:18 am
by ravigoud87
Sure..... any one has any idea of this issue ?
Posted: Mon Jun 15, 2015 6:27 pm
by ray.wurlod
There's obviously some kind of problem with the data in the NEW_STATUS field.
Apart from the mismatched quote, the hex representation looks OK (all of the byte representations are below 256).
What do you see for this value when you select directly from Oracle, for example using TOAD?