Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Leading NULL values for SQLLoader80-Import not excepted?

Re: Leading NULL values for SQLLoader80-Import not excepted?

From: Marc Heravi <marcsimone_at_arcor.de>
Date: Tue, 4 Feb 2003 09:32:15 +0100
Message-ID: <3e3f7a8e$0$9808$9b4e6d93@newsread4.arcor-online.net>

"Frank" <fvanbortel_at_netscape.net> schrieb im Newsbeitrag news:3E3ED779.5020509_at_netscape.net...
> Marc Heravi wrote:
> > Hi,
> >
> > when trying to load TAB-delimited data into a table using sqlldr80 into
> > oracle 8.0.5.0.0
> > the lines that contain leading null values lead me to error message
> > ORA-01401 with the log file attached below.
> >
> > Question: How can i make the oracle database/sqlloader ACCEPT those
leading
> > null values?
> > DDL:
> > CREATE TABLE SF_VORNAME (
> > GESCHLECHT varchar2 (1) NULL ,
> > VORNAME varchar2 (50) NULL ,
> > TIMES varchar2 (25) NULL
> > );
> >
> > Auszug aus dem Logfile:
> > Spalte GESCHLECHT NULL wenn GESCHLECHT = BLANKS
> >
> > Satz 3: Abgelehnt - Fehler in Tabelle SF_VORNAME.
> > ORA-01401: Eingefügter Wert zu groß für Spalte
>
> Viellicht GESCHLECHT NULL wenn GESCHLECHT = '' ?
>

I tried several options to try and get the right result: TRAILING NULLCOLS (this should have been the right choice)

NULLIF column = BLANKS
NULLIF column = ' '
NULLIF column = X'09' (for the delimiter only)

None of that nor combinations of them worked... IMO DBMS should NEVER decide about what to import and not! Reason: Its behaviour becomes inconsistent, in case you import data by commandline-importer or sql-statements (insert into SF_VORNAME (null,null,null) works fine but thats not a real solution!)

Thanks you Frank, still trying and hoping... Marc. Received on Tue Feb 04 2003 - 02:32:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US