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'; #selstmt2
print $selstmt . "\n";
$sth = $dbh->prepare( $selstmt) or die "Can't prepare statement:
$DBI::errstr";
-------------------------------------------------------
here is my output run first with selstmt1 then with selstmt2
-------------------------------------------------------
C:\mac\Perl>perl dbi_test2.pl
SELECT ACCIDENT_EVENT_ID from ACCIDENT_EVENT
C:\mac\Perl>
C:\mac\Perl>
C:\mac\Perl>
C:\mac\Perl>perl dbi_test2.pl
SELECT * from ACCIDENT_EVENT
DBD::ODBC::db prepare failed: (DBD: st_prepare/SQLPrepare err=-1) at
dbi_test2.p
l line 8.
Can't prepare statement: (DBD: st_prepare/SQLPrepare err=-1) at dbi_test2.pl
lin
e 8.
---------------------------------------------------------
question: Why does the prepare fail when using a wildcard but not when
specifying a field?????
