Home » RDBMS Server » Server Utilities » SQL Loader and Binary Data Files
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
Previous Topic: SQL Loader and VB
Next Topic: LINUX AS A O/S FOR ORACLE
Goto Forum:
  


Current Time: Thu Mar 28 11:02:01 CDT 2024