Re: Oracle ODBC Drivers. Long Raws. 32K Limit ??

I'm using Delphi 3 with the "Microsoft ODBC driver for Oracle" V2.00.006325 against Oracle 8, and have noticed a limit of 64K for "long raw".

One solution I can think of, though I haven't needed to resort to it, is to break up your blob into 32K chunks, and store them in individual rows (one-to-many). Its far from ideal, but it would work. When you read the data back you concatenate the chunks back into the real data field.

Brett
mckenzie_at_magna.com.au

Surjit Hunjan <Surjit_at_dualalpha.co.uk> wrote in article <341072ac.1851191_at_news.ftech.net>...
> Hi
>
> I'm Oracle DBA working on NT3.51, Oracle 7.2.2.11. The development
> team are having a problem which we would be greateful for some
> advice/pointers
>
> The developers are using VB4 and Oracle 2.0.3.1.1 Odbc drivers. The
> problem arises when the want to manipulate data stored in Long Raws.
> Below 32K they seem to have no problem, However > 32K they get data
> curruption.
>
> We have spoken to Oracle and they said thier drivers will not support
> fully support Blobs/Long Raws until they end of 1997/ early 98.
>
> We would like to know how if anybody else had similar problems and
> also if there is a solutions or work arounds.
>
>
> Surjit Hunjan
> DualAlpha Limited.
>
> Email: Surjit_at_dualalpha.co.uk
>
Received on Tue Sep 09 1997 - 00:00:00 CDT