What version of the ODBC driver are you using? I assume you are using
Oracle database. Also, the long read length has nothing to do with the
statement not preparing (I don't think). Please post a DBI trace file
(level 9)
Jeff
>
> 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???
>
>
