Oracle NLS change

[Amos.Rosmarin]

Hi there,

A very strange thing happend

I have a simple job

oracle table1 --> transformer --> oracle table2

both tables are on the same DB. Both use the same NLS map (project default)
I pass the value of the field OBJTP as-is with no modifications. The field is defined as varchar2(2 BYTE) in both tables.

When I do :

Code: Select all

select OBJTP from table1 

I get a single value 'A' ( hex value 41)

When I do the same:

Code: Select all

select OBJTP from table2 

I get unprintable char with hex value = C1 ,which is the EBCDIC equivalent to 'A'


Any idea what caused the character mapping change ?
very strange .....


Thanks,
Amos

[roy]

Hi Amos,
This sounds like an issue with:
1. NLS not properly set amongst all componnents (I understand this is not the case)
2. Some how your job implements a hidden call of the Asc() on your column.
In the second case you can simply write a small new (not copied nor exported/imported job) job that reads the specific column and inserts it to a newly created table.
Then test to see was it properly loaded

Awaiting your reply...

[roy]

Update,
I've tried and was successfull in reading the Oracle value to another Oracle table that was newly created, but running the old job Amos refered to resulted in what amos originally mentioned.

Anyone has any idea what might cause a properly working job to go a stray along time?

Any are welcome...

Thanks in advance,