Re: [cx-oracle-users] BLOBs > 2GB

[Anthony T. <ant...@gm...>]

On Tue, May 11, 2010 at 3:36 PM, VJ Kumar <vj...@gm...> wrote:
> Anthony Tuininga <anthony.tuininga@...> writes:
>
>>
>> On Tue, May 11, 2010 at 2:18 PM, VJ Kumar <vjkmail@...> wrote:
>> > Anthony Tuininga <anthony.tuininga@...> writes:
>> >
>> >>
>> >> Hmm, just a question: why would you want to write more than 2 GB at a
>> >> time? Why not write it in chunks smaller than 2 GB?
>> >
>> > I would be happy to,  but the write call does not have the offset
>> > parameter as in:
>> >
>> > write(buffer, offset, length).  Or does it ?
>>
>> It does indeed. Its even in the documentation....
>>
>> write(data, offset = 1)
>>
>
> Right you are ! I did see the parameter,  but I wrote my previous remark
> incorrectly:  what I meant was that there is no 'length' parameter (rather than
> no 'offset') that would allow writing chunks without copying to a smaller buffer.

Right. Well, if you already have the data in memory there should be no
need to split it like that. Then again, how did it get there in the
first place? Perhaps it can be chunked from the original source?

> By the way,  OCI now has extended writes(OCILobWrite2) with 64 bit offsets and
> lengths.

Nice. I'll have to take a look at that and see if that will resolve
the problem for you. If I made the use of OCILobWrite2 possible, would
you be able to do some testing for me? I can't see that I am going to
be able to write larger than 2 GB data particularly easily at this
time. :-)

Anthony