-
Hey,
I am using >= and <= in my sql loader control file. See below.
INTO TABLE COMPENS_CDR_LOAD
APPEND
WHEN (1:3) = '111'
AND (959:959) ='1' AND (34:34)='S' AND (32:33) > '22' AND (32:33) < '32'
TRAILING NULLCOLS
( .....
.....)
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.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|