Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Loader character set

880836Oct 28 2011 — edited Oct 28 2011

Hi I am using sql loader to load mainframe binary file
my control file is

options (direct=true,errors=9999999,rows=1000,bindsize=999000)
UNRECOVERABLE
LOAD DATA
CHARACTERSET 'WE8DBCDIC1146' --'WE8EBCDIC37C' WE8BS2000 WE8EBCDIC500
INFILE 'p:\temp\GLSPA86E_BOOKVAL_EBCDIC.bin' "fix 177 buffers 1024"
TRUNCATE
INTO TABLE test_ld
( col1 position(1:18) char,
col2 position(24:38) char,
col3 position(94:101) decimal
)

I have tried all four character sets that Oracle says it supports (form it's document)
sql loader reports the following error
SQL*Loader-266: Unable to locate character set handle for WE8DBCDIC1146.

Could any one help!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2011

Added on Oct 28 2011

#database-key-features, #export-import-sql-loader-external-tables

3 comments

1,065 views