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
 

QuestionForm edit

Subject This website
Extension SqlPlugin
Version Foswiki 1.1.3
Status Task filed
Related Topics
Topic revision: r2 - 29 Jan 2014, MichaelDaum - This page was cached on 10 Jan 2018 - 16:07.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License