XML data load using SQL*Loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: XML data load using SQL*Loader

  1. #1
    Join Date
    Feb 2002
    Posts
    70

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    70

    Wink

    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
  •  



Click Here to Expand Forum to Full Width