loading html into a table using sql*loader

From: Patrick Schlaepfer <patrick_at_schlaepfer.com>
Date: Mon, 05 Oct 1998 13:31:28 +0200
Message-ID: <3618AE10.3A19556D_at_schlaepfer.com>

I´m trying to load html-code into a varchar field using sql*loader. Here's the table def and the ctl. code

LOAD DATA INFILE 'peri_load_www_html_data.txt' INTO TABLE www_html_data replace
FIELDS TERMINATED BY '$'
TRAILING NULLCOLS
(lang_nr,
 ref_html_nr,
 specgrp_nr,
 specdef_nr,
 html_art,
 lf_nr,
 term_html)

create table www_html_data (

        lang_nr     integer   not null,
 ref_html_nr        integer     not null,

 specgrp_nr integer not null,
 specdef_nr integer not null,
 html_art integer not null,
 lf_nr integer not null,
 term_html varchar2(2000)
);

sometimes I get the error:
Field in data file exceed maximum spefied length in Field

With the same input file loading into a ingres table no errors occur.

Any help?

Pat Received on Mon Oct 05 1998 - 13:31:28 CEST