On Thu, Jul 17, 2003 at 10:50:28AM -0000, Diego Kuperman wrote:
> Hi,
>
> I was experiencing problems with BLOBs. After reading the documentation of
> DBD::Oracle 1.14, I found this:
>
> >Handling LOBs
> >
> > When fetching LOBs, they are treated just like LONGs and are
> > subject to $sth->{LongReadLen} and $sth->{LongTruncOk}. Note
> > that with OCI 7 DBD::Oracle pre-allocates the whole buffer
> > (LongReadLen) before constructing the returned column. With
> > OCI 8 it grows the buffer to the amount needed for the
> > largest LOB to be fetched so far.
>
> When I tried, I noticed that $sth->{LongTruncOk} work as expected but
> $sth->{LongReadLen} don't. Then I was looking arround and remembered that
> I used this some years ago with mySQL but on that opportunity I set the
> 'LongReadLen' on the database handler ($dbh). I tried this and it works !
In the DBI docs it says that $sth->{LongReadLen} is copied from
$dbh->{LongReadLen} and that changing $sth->{LongReadLen} usually
has no effect.
Tim.
> Is there an error in the documentation or I miss something?
>
> I hope this is the correct list to post this. If not: SORRY !
>
> ]:DK:[
>
>
>
