Here is my code:
----------------------------------------
use DBI;
$dbh = DBI->connect('DBI:ODBC:LNX1', 'nsite', 'nsite', {LongReadLen =>
20000, LongTruncOk => 1});
$dbh->{LongReadLen} = 200000;
$dbh->{LongTruncOk} = 1;
#$selstmt = "SELECT NOTE_TEMPLATE_TXT from NOTE_TEMPLATE"; #selstmt1:
NOTE_TEMPLATE_TXT is a clob field
#$selstmt = "SELECT * from NOTE_TEMPLATE"; #selstmt2
$selstmt = "SELECT NOTE_TEMPLATE_DESC from NOTE_TEMPLATE"; #selstmt3:
NOTE_TEMPLATE_DESC is a varchar field
print $selstmt . "\n";
$sth = $dbh->prepare( $selstmt);
------------------------------------------
here is my output, first with $selstmt1, then $selstmt2, then $selstmt3
------------------------------------------
C:\mac\Perl>perl dbi_test2.pl
SELECT NOTE_TEMPLATE_TXT from NOTE_TEMPLATE
DBD::ODBC::db prepare failed: (DBD: st_prepare/SQLPrepare err=-1) at
dbi_test2.p
l line 9.C:\mac\Perl>perl dbi_test2.pl SELECT * from NOTE_TEMPLATE DBD::ODBC::db prepare failed: (DBD: st_prepare/SQLPrepare err=-1) at dbi_test2.p l line 9. C:\mac\Perl>perl dbi_test2.pl SELECT NOTE_TEMPLATE_DESC from NOTE_TEMPLATE C:\mac\Perl> ---------------------------------------------- Why does LongReadLen not work??? How can I select a clob field???
