here is the code and the following is the error... this works fine on other computer and server but having one issue with this specific server (win.2000, perl v5.6..)
#!perl
use DBI;
my $dbh = DBI-connect "dbi:Oracle:Db01", "developer", "dev12" );
my $statement = $dbh->prepare( "SELECT * from developer.stats" );
$statement->execute();
my @row = $statement->fetchrow_array();
print @row;
error message:
C:\>connect.pl
DBD::Oracle::db prepare failed: ORA-00942: table or view does not exis
+t (DBD ERR
OR: OCIStmtExecute/Describe) at C:\connect.pl line 9.
Can't call method "execute" on an undefined value at C:\connect.pl lin
+e 11.
table does exist and connects and executes everywhere else..
baffled brother Zo.
|