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

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent Help

Re: Urgent Help

From: The Ghost <The_at_Ghost.com>
Date: Wed, 07 Mar 2001 02:33:11 GMT
Message-ID: <H5hp6.33376$c7.10474928@news3.rdc1.on.home.com>

Load the data into temp table same structure but no mandatories. Whats 's the field definitions.
I an H or T record the data file contains nothing (null) "Jack Dawson" <srik_at_cnet.com> wrote in message news:983vat$sml$1_at_innbox.cnet.com...
> I have a file in which the data is like this
>
> H1 4600019786R03020195010195013195
> R0300000110720790101950000002090010295
> R0300000000000580202950068400271010295
> T1 000000 00000000000 000025 00000184637
>
> I need to load this data in 2 different tables they are .....
 header_table,
> detail_table
>
> My sql loader uses the WHEN clause so that the tables are loaded
>
> WHEN it starts with H
> it goes into header_table,
> WHEN it starts with R
> it goes into detail_table,
> WHEN it starts with T
> it goes into remaining columns in header_table
>
> However when loading the T1 record into header _table i get an error
>
> ORA-01400: cannot insert NULL into ("HEADERS_TABLE")
>
> I am trying all possible ways to get it solved but of no avail
>
> Please help, it helps me to proceed further
>
> Thanks
> Jack
>
>
>
>
>
>
>
Received on Tue Mar 06 2001 - 20:33:11 CST

Original text of this message

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