CSV file to Oracle

[hexa]

Hi,

My job design is

Seq.File --->Transformer ---->Oracle DB
My source file is CSV format.

When I am loading in to Oracle I am getting below error.

Error-1

Oracle_Enterprise_3,0: Call to sqlldr failed. Return code = 256
Please see loader logfile: /ascl/dsadm/Ascential/DataStage/Scratch/ora.11858.910475.0.log for details.

Error-2

Oracle_Enterprise_3,0: SQL*Loader: Release 9.2.0.1.0 - Production on Mon Jul 18 14:33:16 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: ora.11858.910475.0.ctl
Character Set WE8ISO8859P1 specified for all input.
Data File: ora.11858.910475.fifo.0
File processing option string: "FIX 267"
Bad File: ora.11858.910475.0.log.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct - with parallel option.
Table TEST, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
A 1:10 10 DATE YYYY/MM/DD
C 11:16 6 PACKED DECIMAL (10, 0)
B 17:266 250 CHARACTER
SQL*Loader-951: Error calling once/load initialization
ORA-24329: invalid character set identifier
Log file contents:

Thanks in Advance

[Sunshine2323]

Hi Hexa,

You can load the data using the Upsert method.

[hexa]

Hi Sunshine,

Why its not working with Laod method.


what is the meaning of the error
output,0: SQL*Loader-951: Error calling once/load initialization

can any body explain.

Thanks in advance

hexa

[chulett]

It looks like it was caused by the next error logged:

ORA-24329: invalid character set identifier

[ray.wurlod]

There's a file called ora.11858.910475.0.log.bad that will tell you what the problem in sqlldr was. You can use the oerr command to decode the Oracle error numbers, and usually get advice about how to remedy the errors.