in reply to DBI fetch fails with "LOB value truncated from 80 to 80"

Try setting the LongReadLen and LongTruncOk params on your dbh handle.... 
$dbh->{LongReadLen} = 66000;
$dbh->{LongTruncOk} = 1;

[download]

-Blake

Replies are listed 'Best First'.
Re: Re: DBI fetch fails with "LOB value truncated from 80 to 80"
by andye (Curate) on Nov 09, 2001 at 16:06 UTC
    blakem is correct. A bit more info: This is from memory (haven't got the right book to hand) but should be roughly right. ;)

    hth,
    andy.

[reply]
      Since nobody asked the obvious follow-up to my node, I'll do it myself....

      Q: What should LongReadLen actually be? How did you arrive at 66000?

      A: I dunno... cut'n'pasted it from some of my old code, itself being cut'n'pasted from a usenet post. If anyone knows the significance of 66000 or has another "favorite" value, I'd love to hear about it.

      -Blake

[reply]
        _Programming the Perl DBI_ (Alligator Descartes & Tim Bunce) is a great source for this stuff...Look under DBD:Oracle, page 301. Says LongReadLen attribute seems limited to 65535 bytes under Oracle 7, but building DBD:Oracle with Oracle 8 gives you a 4GB limit. Don't ask me why, though.
[reply]
Re^2: DBI fetch fails with "LOB value truncated from 80 to 80"
by Anonymous Monk on Jan 10, 2014 at 10:16 UTC
    The below given dbh is working as expected. thanks
[reply]
Re^2: DBI fetch fails with "LOB value truncated from 80 to 80"
by Anonymous Monk on Jun 04, 2021 at 14:17 UTC
    Twenty years on... this particular piece of arcane wizardry is still hitting the spot!
[reply]

In Section Seekers of Perl Wisdom