XML data load using SQL*Loader

Hi all,

Can any one please suggest how to load XML data into a table using SQL*LOADER utility.

Scenario is:
I am getting a dat file in a flat file, where it contains XML data for one column. While I am trying to load that dat file using SQL Loader, its giving me "the field in data file exceeds the maximum length of the column "xyz".

But actually the size of the column "xyz" is varchar2(4000) and the datalength what I am getting is less than 3000 bytes.

Thanks in advance,

I got the solution. :)

in the control file, I specified CHAR(4000) for the column "xml_col"

Ex:

load data
infile 'abc.dat'

into table xzy
insert
(
xml_col char(4000)
)