XML data load using SQL*Loader
Can any one please suggest how to load XML data into a table using SQL*LOADER utility.
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"
into table xzy
Click Here to Expand Forum to Full Width