This question about This website: Task filed
Oracle Long Column Type
I got this oracle error while using the SqlPlugin:
ERROR: DBD::Oracle::st fetchrow_hashref failed: ORA-24345:
A Truncation or null fetch error occurred
(DBD ERROR: ORA-01406 error on field 2 of 2, ora_type 8, LongReadLen too small and/or LongTruncOk not set)
[for Statement " select view_name,text from all_views "]
As a workaround I patched
lib/Foswiki/Plugins/SqlPlugin/Connection.pm
by adding the following
near the end of the
connect
function:
$db->{LongTruncOk}=1;
$db->{LongReadLen}=1024;
This makes the sql statement to truncate but not to fail if the column is too long
and changes the length from 80 to 1024, which is long enough in my usecase.
See
man DBD::Oracle
for an explanation of these options.
--
HansJosefKoehler - 29 Jun 2012
Thanks for the patch.
See
Tasks.Item12737
--
MichaelDaum - 29 Jan 2014