Perl CGI Scripts - Oracle Data
Truncated Error Troubleshooting
Error Message (from Apache web server error_log file on
Windows):
DBD::ODBC::st fetchrow_arrayref failed: [Oracle][ODBC]String data, right
truncated. (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated DBI attribute
LongTruncOk not set and/or LongReadLen too small) - This error is the
result of attempting to insert too much data into an Oracle CLOB or
BLOB column.
Solution: If objects larger than 10,000 bytes need to be inserted into
Oracle CLOB or BLOB columns, increase the value entered into the Max
Submit Size field on the CGIScripter
Web Site tab.
