Oracle Database Discussions

Hi,

How to use VARCHAR in an sqlldr control file to load a varchar data type.

The sqlldr documentation says that VARCHAR is a datatype supported by sqlldr.

But could not load data using VARCHAR datatype.

LOAD DATA
INFILE Test.dat
APPEND INTO TABLE VARTEST
FIELDS TERMINATED BY ','
(Col1 VARCHAR(10))

I could load data in sqlldr using the CHAR datatype in the control file
as well as by leaving the datatype blank (default).

The Oracle version used is 10g.

Thanks in advance.

----
Abraham V K