oracle sql loader - datatype

[tshen]

We tried to sql*loader to upload a flat file onto Oracle 9i.
It seems all the fileds on the flat file with a data type as pack decimal field got kick out? is there way to resolve this? Thanks

 

[tigreeuropeo]

You say you were trying to upload a 'flat file' with sql loader. Be careful with decimal numbers, if they are in text format (like 1234.56) you have to use DECIMAL EXTERNAL.
Hope this works for you.

 

[itbl]

try this:

load data
characterset 'WE8EBCDIC500'
infile 'file.dat'
into table schema.table
(
packed_decimal_field DECIMAL(11,2)
)

It works in loading AS400 file.