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
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