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
Tags (1)
1 REPLY
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