| SQL Loader and Binary Data Files [message #368031] |
Thu, 14 October 1999 03:01 |
Mario Zimmermann
Messages: 1
Registered: October 1999
|
Junior Member |
|
|
Is it possible to import binary data files with SQL Loader?
I have tried to import a binary file which contains integer values with the following control file:
OPTIONS (
ERRORS=0
)
LOAD
INFILE bin.dat
APPEND
RECLEN 12
INTO TABLE bin_test
FIELDS (
F1 INTEGER,
F2 INTEGER,
F3 INTEGER
)
This works very well so far, but if one of the integer values in the datafile has the value 10 (hex 0a) SQL Loader treats this value as a line feed character and stops processing the current record. Importing the rest of the datafile results in a mess, of course.
Is there a way to tell SQL Loader that the import file is in binary format?
Many thanks in advance.
Mario
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
