Oracle Bulk Load : Unable to locate character set

Highlighted
One Star

Oracle Bulk Load : Unable to locate character set

Hi,
I'm trying to feed a database using tOracleOutputBulk and tOracleBulkExec (with TOS 2.4 and Perl), but I have an error with the character set :
Starting job chipsToClims at 15:21 12/06/2008.
connecting to socket on port 3813 ...
connected
SQL*Loader-266: Unable to locate character set handle for ISO.
SQL*Loader: Release 9.2.0.1.0 - Production on Thu Jun 12 15:21:39 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL*Loader: Release 9.2.0.1.0 - Production on Thu Jun 12 15:21:40 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL*Loader-266: Unable to locate character set handle for ISO.
sqlldr exited with value 3
Job chipsToClims ended at 15:21 12/06/2008.

Anyone has an idea about the way to solve this problem ?

PS : My screenshot function doesn't work, I give you a schema of my job :
tOracleInput -----------> tMap --------------> tOracleOutputBulk
tPostJob ------------------> tOracleBulkExec
One Star

Re: Oracle Bulk Load : Unable to locate character set

Perhaps you have to set "the encoding type" in the "advance setting" of the tOracleBulk to 'CUSTOM' and use a encoding type which is know by Oracle. I 'm not a expert in Oracle, but you could take a look at this: http://www.daylight.com/meetings/emug04/Delany/charsets.html

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download