Re: SQL*Loader Question - please

[Quoted] You chose the packed decimal, you need to use external decimal.

Here is from the manual at tahiti.oracle.com (note the words below "These datatypes are the human-readable, character form of numeric data")

Numeric EXTERNAL
The numeric EXTERNAL datatypes are the numeric datatypes (INTEGER, FLOAT, DECIMAL, and ZONED) specified with the EXTERNAL keyword, with optional length and delimiter specifications.

These datatypes are the human-readable, character form of numeric data. Numeric EXTERNAL may be specified with lengths and delimiters, just like CHAR data. Length is optional, but if specified, overrides position.

The syntax for the numeric EXTERNAL datatypes is shown as part of datatype_spec.

  Note: The data is a number in character form, not binary representation. Therefore, these datatypes are identical to CHAR and are treated identically, except for the use of DEFAULTIF. If you want the default to be [Quoted] null, use CHAR; if you want it to be zero, use EXTERNAL. See also Setting a [Quoted] Column to Null or Zero and DEFAULTIF Clause.

FLOAT EXTERNAL data can be given in either scientific or regular notation. Both "5.33" and "533E-2" are valid representations of the same value.

"Andre Norman" <andre.norman_at_sympatico.ca> wrote in message news:3RwBa.6278$y77.653295_at_news20.bellglobal.com...
> Hi ,
> 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
>
> Any help with this is appreciated.
>
> Thanks,
>
>
>
Received on Fri May 30 2003 - 02:10:20 CEST