-
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,
________________
ShanDJ
-
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)
)
________________
ShanDJ
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
|