Re: SQL*Loader and LOB-Fields

In article <p3oY6.1$9h5.28701_at_news.salzburg-online.at>, "Thomas says...
>
>I have an Oracle 8.0.6 Database and will import data with SQL*Loader to a
>table with a CLOB-field.
>
>When the data in the CLOB-Field is equal or higher than 256 byte then i get
>an SQL*Loader-error "field in data-file is greater than maximum length"
>(translated from german error-message). When the data is lower than 256 byte
>the import works.
>
>The table-description:
>----------------------
>
>CREATE TABLE KUNDE (
>kunum NUMBER(6),
>kuname VARCHAR2(35),
>kustr VARCHAR2(35),
>kuort VARCHAR2(35),
>abeschr CLOB);
>
>
>The control-file for SQL*Loader:
>--------------------------------
>
>LOAD DATA
>INFILE 'KUNDE.dat' "STR X'7C'"
>APPEND INTO TABLE KUNDE
>FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY "'"
>(kunum,kuname,kustr,kuort,

abeschr char(10000) ENCLOSED BY '<startlob>' AND '<endlob>')

sqlldr defaults the external datatype to CHAR(255), tell sqlldr its bigger than that.

>
>
>The data-file for SQL*Loader:
>-----------------------------
>
>224001;'Huber Josef';'Hauptstrasse 15';'Zell am See';<startlob>08.09.94
>09:55
>mit Herrn Maier besprochen,daß
>ich am Freitag bis ca. 14:30 Uhr erreichbar
>bin und Hr. Moser oder Fr. Hinterhofer
>zurückruft oder ein Mitarbeiter der Firma.
>
>08.09.94 10.42 mit Hr. Moser gesprochen, er 
>versucht FIBU und Lagerwirtschaft auf andere 
>Maschine zu kopieren. 
><endlob> |
>
>
>Thanks for your help !
>
>Tom
>
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp