RE: Limit on length of decode arguments??

2002-06-11 Thread Robson, Peter
Original Message- > From: Bob Metelsky [mailto:[EMAIL PROTECTED]] > Sent: 10 June 2002 23:03 > To: Multiple recipients of list ORACLE-L > Subject: Limit on length of decode arguments?? > > > Hello all > > In an effort to clean up data as I'm importing,

Limit on length of decode arguments??

2002-06-10 Thread Bob Metelsky
Hello all In an effort to clean up data as I'm importing, I need to pass the bad data to decode. It seems onece I pass < 250 chars the code fails with SQL*Loader-350: Syntax error at line 93. Token longer than max allowable length of 258 chars The articles on metalink hint on problems w