SQL*Loader Question - please

From: Andre Norman <andre.norman_at_sympatico.ca>
Date: Thu, 29 May 2003 19:34:05 -0400
Message-ID: <3RwBa.6278$y77.653295_at_news20.bellglobal.com>

Hi ,
[Quoted] Im trying to use SQL*Loader's direct load method to load several million records into my oracle table.

My datafile contains numeric values such as the following:

+000000000376.04
-000000000154.70

The following entry is in my ctl file,

AMOUNT_BALANCE POSITION(133:148) DECIMAL (14,2) , which according to the documentation, should work. but this is what I get:

ORA-02357: Packed Decimal conversion error ORA-07409: slpdtb: invalid packed decimal nibble. Record 99975: Rejected - Error on table TEST.TABLE1, column AMOUNT_BALANCE

[Quoted] Any help with this is appreciated.

Thanks, Received on Fri May 30 2003 - 01:34:05 CEST