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