Urgent Help

From: Jack Dawson <srik_at_cnet.com>
Date: Tue, 6 Mar 2001 16:38:16 -0800
Message-ID: <983vat$sml$1@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 - 18:38:16 CST