> You can cure this error by setting LongReadLen to a bigger number
I know. I'm trying to find a way to do it programmatically.
>> When I $sth->fetch* a CLOB the following is sent to STDERR
>>
>> DBD::Oracle::st fetch failed: ERROR fetching field 2 of 1. LOB value
>> truncated from 10347 to 80. DBI attribute LongReadLen too small and/or
>> LongTruncOk not set at ./dumpdb.pl line 211.
>>
>> The problem is I can't get the error in my code. Somewhere in the
...<snip>
>I am not sure what you mean here. If you were to post some code, it would
>clarify things and attract more help.
my $st = "select $clob_field from $table where $column in
($search)";
my $sth = $dbh->prepare($st);
$sth->execute;
my @rows = $sth->fetch;
The fetch causes the above error to be sent to STDERR. There is no error
returned.
i.e.
my @rows = $st->fetch or die "Fetched Failed!\n";
the die never happens.
I want the program to be able to handle the error.
i.e. parse the error message for the required size. Set LongReadLen to the
size and reselect the data.
************************************************************************************************
This email message and any attached files may contain information that is
confidential and subject of legal privilege intended only for use by the individual
or entity to whom they are addressed. If you are not the intended recipient or the
person responsible for delivering the message to the intended recipient be
advised that you have received this message in error and that any use, copying,
circulation, forwarding, printing or publication of this message or attached files is
strictly forbidden, as is the disclosure of the information contained therein.
If you have received this message in error, please notify the sender immediately
and delete it from your Inbox.
************************************************************************************************
