Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Inserting a long raw column 2

Re: Inserting a long raw column 2

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sun, 07 Jan 2001 16:52:19 GMT
Message-ID: <79166.240485$U46.7515807@news1.sttls1.wa.home.com>

Wouldn't that be a problem with the driver? I have used reports that use an ODBC Oracle driver that can read LOBS.
Jim

--
"Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message
news:3A587A8F.9022DE4F_at_0800-einwahl.de...

> Hi Mike,
>
> It is not true that you can always use a LOB instead of LONG (RAW).
Example:
> MDAC 2.5 (OLE DB) which does not know anything about LOBs but knows how to
> handle LONGs.
>
> The reason is that LONGs do not use handles.
>
> It took us quite an effort to pass our BLOBs as a LONG RAW parameter in a
> procedure. The solution was to use a global temporary table for
conversion.
>
> Martin
>
>
Received on Sun Jan 07 2001 - 10:52:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US