[odb-users] Inserting CLOB greater having size greater then 12288

[roberto minarelli]

Hi again Boris,
I am stuck on this problem
I have a table that is like
Table_A
{
string UUID
string sLob CLOB
}

I start to insert a lob of 70k but it doesn't fit
So I reduced the length until It is successfully inserted
This happens with

OL 8.8
libodb-2.5.0-b.25.so
libodb-oracle-2.5.0-b.25.so
Oracle 19c

if I try with the same library and the same OS but Oracle 11g it fits

So what could be the cause?
I tried also to debug odb library but didn't understand what happens

the Oracle client is always the 12.2.0

Do you believe that installing the odb 2.5.0 will solve the situation?

Please let me know as soon as possible

Thank you in advance

Regards
Roberto Minarelli Della Valle

Il giorno gio 1 feb 2024 alle ore 10:26 Boris Kolpackov <
boris at codesynthesis.com> ha scritto:

> roberto minarelli <roberto.minarelli.de at gmail.com> writes:
>
> > have you an update for this issue?
>
> No, I haven't had a chance to look into this and unfortunately won't
> be able to for the foreseeable future.
>
>
> > I tried to debug the callback but I couldn't step into it
>
> Try to set the breakpoint inside the callback. This should allow
> you to step through it without having to go through OCI code (which
> I assume is what's causing the difficulty).
>
>
> > My guess is that the callback is called three times, each of which with a
> > chunk of 4Kb of maximum dimension when writing
> > And it is called maximum three times
> > first time with OCI_FIRST_PIECE
> > second time with OCI_NEXT_PIECE
> > and finally with OCI_LAST_PIECE
>
> What is the size of the data you are trying to insert and will it fit
> into the three 4Kb chunks?
>
> Do a little bit of digging and thinking on your own, I am willing to
> help guide you in the right direction but "it doesn't work, help"
> attitude is not going to get us far with this approach.
>