Re^2: Oracle DBI CLOB Issue: fetch Column TRUNCATED

Scott,

Thanks. You may be right. I was just reviewing the CHANGE LOG (something I have never really done). I see the following for DBD::Oracle:

=head1 Changes in DBD::Oracle 1.07 5th June 2001
....
Fixed error in 'LOB value truncated' error thanks to Paul Walmsley.
....

So they have apparently corrected some things dealing with LOB truncation. I did not realize how old this DBD::Oracle module apparently is. This may or may not be the solution but I suspect since I am doing some rather straight-forward calls, the versions I have probably cannot support it.
I will review versions of DBD::Oracle and DBI and look to upgrade before banging my head against this anymore.

THANKS!

Comment on Re^2: Oracle DBI CLOB Issue: fetch Column TRUNCATED

Replies are listed 'Best First'.
Re^3: Oracle DBI CLOB Issue: fetch Column TRUNCATED by Anonymous Monk on Dec 19, 2013 at 05:16 UTC
Instead of '$dbh->{LongReadLen} = 512 * 1024' you can use $dbh->LongReadLen(512 * 1024). This may work for older version	[reply]