Database Utilities (MOSC)

MOSC Banner

Issue while uploading positional mix byte data file using Sql Loader

edited Dec 14, 2013 12:38AM in Database Utilities (MOSC) 1 commentAnswered
Hi,
I am trying to load positional data file using Sql Loader.
Data files having only single byte characters are getting uploaded properly.
But some Data files are having Single and Multi byte characters both. In these cases I am facing the issue.

Please find below one mix byte record that I am trying to upload and facing issue.

"C000001000000000000008011380249TRY92110001                                                             100152                             2012011120120111012300723034   TR080012300723003995528200        ŰNSPED PAKET SERVISI SAN VE TIC A.S0000000002954990000000000 00000023TARGET DETAILS INVALID             0000000000TARGET DETAILS INVALID (MERC_00000023)                                                                                                      C00000000        05377738000000002                                                                                               4TR           "

Here is the Sql Loader control file that I am using.

LOAD DATA
CHARACTERSET UTF8
infile *
append
into table XX_TEST_STG_TBL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center