I'm having some trouble with DBD::Oracle...

When I execute this code:

***

   $sth = $dbh->prepare("select * from abbrev where type = ?");

   $sth->execute("PAYMENT");

   while((@row) = $sth->fetchrow_array) {
     print(join(", ", @row), "\n");
   }
   $sth->finish;


***

... no rows are returned.  However, when I execute this code here:

***

   $sth = $dbh->prepare("select * from abbrev where type = 'PAYMENT'");

   $sth->execute();

   while((@row) = $sth->fetchrow_array) {
     print(join(", ", @row), "\n");
   }
   $sth->finish;


***

... it correctly returns a row. Does anyone know what the problem might be? I'm running DBD::Oracle 1.16 on Redhat Enterprise Linux 3, accessing Oracle 9.2.0.5.0.

Thanks,
Bart



Reply via email to