Re: Re: DBI fetch fails with "LOB value truncated from 80 to 80"

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

blakem is correct. A bit more info:

http://search.cpan.org/doc/TIMB/DBD-Oracle-1.12/Oracle.pm#Handling_LOBs
LongReadLen sets the longest # of bytes that the DBD will read from Oracle
LongTruncOK, if set, allows a string longer than LongReadLen to be truncated. So you get the first bit of it, rather than none of it
This is stricly an Oracle thing. Users of other databases can ignore.

This is from memory (haven't got the right book to hand) but should be roughly right. ;)

hth,
andy.

Comment on Re: Re: DBI fetch fails with "LOB value truncated from 80 to 80"

Replies are listed 'Best First'.
Re: Re: Re: DBI fetch fails with "LOB value truncated from 80 to 80" by blakem (Monsignor) on Nov 10, 2001 at 00:40 UTC
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]
Re: Re: Re: Re: DBI fetch fails with "LOB value truncated from 80 to 80" by biograd (Friar) on Nov 14, 2001 at 07:33 UTC
_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]

In Section Seekers of Perl Wisdom