Answer:

Try to include the format for the field,

Who POSITION(51) CHAR    "TO_NUMBER(:sal,'$99,999.99')",
This might work.

-Bhavesh
 

Question:

>hi everyone
>
>i have troubles with the sqlloader, the situation is :
>
>field who is defined in the database as number (5,2)
>
>in the input file i have that field defined as 00025.00 and in the control
>file
>i gave up the name off the field with decimal external but this doesn't
load
>the data.
>
>any one knows wich datatype i must use with the sql loader ?
>
>thanks
>
>[email protected]
>
>