Hello Bart,
I run DBD::Oracle version 1.16 with DBI 1.41-ithread
on Windows XP accessing Oracle8i Release 8.1.7.4.1
I can't reproduce your problem.
Do you check for errors? Do you use RaiseError?
Did you try to produce a trace? Add something like this:
DBI->trace(9,"dbitrace.txt");
Tuesday, November 23, 2004, 11:13:30 PM, you wrote:
BK> I'm having some trouble with DBD::Oracle...
BK> When I execute this code:
BK> ***
BK> $sth = $dbh->prepare("select * from abbrev where type = ?");
BK> $sth->execute("PAYMENT");
BK> while((@row) = $sth->fetchrow_array) {
BK> print(join(", ", @row), "\n");
BK> }
BK> $sth->finish;
BK> ***
BK> ... no rows are returned. However, when I execute this code here:
BK> ***
BK> $sth = $dbh->prepare("select * from abbrev where type = 'PAYMENT'");
BK> $sth->execute();
BK> while((@row) = $sth->fetchrow_array) {
BK> print(join(", ", @row), "\n");
BK> }
BK> $sth->finish;
BK> ***
BK> ... it correctly returns a row. Does anyone know what the problem might
BK> be? I'm running DBD::Oracle 1.16 on Redhat Enterprise Linux 3,
BK> accessing Oracle 9.2.0.5.0.
cu
Wieland mailto:[EMAIL PROTECTED]
