Re: SQL*Loader and binary data
From: FC <flavio_at_tin.it>
Date: Sat, 10 May 2003 15:23:53 GMT
Message-ID: <dQ8va.140796$K35.3274286_at_news2.tin.it>
Date: Sat, 10 May 2003 15:23:53 GMT
Message-ID: <dQ8va.140796$K35.3274286_at_news2.tin.it>
You cannot use the syntax X'...' to embed hexadecimal values inside the
control script after the BEGINDATA section. It doesn't work, all characters
are interpreted as data.
In order to include binary data after the BEGINDATA section, you should be
100% sure of not having control character like chr(13) or chr(10) or chr(0),
which would terminated the loading prematurely.
This explains why normally RAW data must be provided in external file(s).
At that point you can choose among VARRAW, VARRAWC or simply RAW, depending
on the format of the binary strings (varying length or fixed length).
Bye,
Flavio
Received on Sat May 10 2003 - 17:23:53 CEST