binary code

[ysrini9]

Hi All

We are getting source data from JDE EDWARDS. In that we have

3 columns like (Source)

Column Datatype length

DDDD binary 4
YYYY binary 4
AAAA binary 4
SSSS binary 4

in oracle (target)

Column Datatype length

DDDD varchar2 20

YYYY varchar2 20

AAAA varchar2 20

SSSS varchar2 20

how to covert binary datatype into oracle fromat

I used like this (ASCII(Linkname.DDDD)) I got the below error

" literal does not match format string "

Please help on this Advance thank u

Regards
srini