LongReadLen problem with clobs

2003-08-18 Thread John MccLain
Here is my code: use DBI; $dbh = DBI->connect('DBI:ODBC:LNX1', 'nsite', 'nsite', {LongReadLen => 2, LongTruncOk => 1}); $dbh->{LongReadLen} = 20; $dbh->{LongTruncOk} = 1; #$selstmt = "SELECT NOTE_TEMPLATE_TXT from NOTE_TEMPLATE"; #selstmt1: NOTE_TEMP

DBD::ODBC select * from ....

2003-08-15 Thread John MccLain
Here is my code... -- use DBI; $dbh = DBI->connect('DBI:ODBC:LNX1', 'nsite', 'nsite') or die "Can't connect to Oracle database: $DBI::errstr"; #$selstmt = 'SELECT ACCIDENT_EVENT_ID from ACCIDENT_EVENT'; #selstmt1 $selstmt = 'SELECT * from ACCIDENT_EVENT';#s