decode function limit
ReposJul 31 2008 — edited Aug 1 2008Hi
I try to use decode function im the sqlldr control file it gives error
Token longer than max allowable length of 258 chars
is there is nay limitation for decode function
i am using the following decode in my control file , pls advise is there is any workaround for this
, this is the field what i am decoding in the controlfile
area position(46:47) char "decode(:key,'21','OH','22','OH','24','OH','25','OH','27','OH','29','OH','30','OH','31','OH','34','OH','35','OH','37','OH','38','OH','39','OH','41','OH','42','OH','43','OH','45','OH','47','OH','49','OH','50','OH','51','OH','54','OH','55','OH','57','OH','58','OH','59','OH',:area)"
rds