Re: SQLLDR loading BLOBS

From: <qiangye_at_my-deja.com>
Date: Fri, 01 Sep 2000 09:00:23 GMT
Message-ID: <8onr70$uu9$1@nnrp1.deja.com>

I think LONG type is much better than BLOB itself, which needs special treatments, no matter in SQLPLUS, Oracle ODBC, OCI. But, LONG type could be treated as a normal data type as others.

So far the only difference to me is LONG type is limited to 2G bytes, while LOB to 4G bytes.

Qiang Ye

ZTE Corp.

In article <8oeu10$gds$1_at_nnrp1.deja.com>, don_leclaire_at_my-deja.com wrote:
> I am trying to load a variable length JPEG's
> into an Oracle 8i database using SQLLDR, these are
> coming from a flat file and I need to know if anyone has
> completed this..
>
> I need to know how to do this or if the JPEG format has a
> reserve character that I can delimit with
>
> HELP HELP HELP!!!!!!!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 01 2000 - 04:00:23 CDT