I am using >= and <= in my sql loader control file. See below.
INTO TABLE COMPENS_CDR_LOAD
WHEN (1:3) = '111'
AND (959:959) ='1' AND (34:34)='S' AND (32:33) > '22' AND (32:33) < '32'
Oracle gave me SQL Loader--350 Error:
Illegal combination of non-alphanumeric characters.
The type of the field in control file was char (I tried number too). The corresponding
column datatype was varchar2. I also changed it to be number and integer.
However, Oracle gave me the same error. I also tried to take the quote off. Same
error was given.
Anyone could help me.
I appreciate your responses.
Click Here to Expand Forum to Full Width