Can't really help without seeing the code. Please post.
Ilya Sterin
-----Original Message-----
From: Dennis McCoy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 12, 2001 6:14 PM
To: [EMAIL PROTECTED]
Subject: perl DBI method fetchrow_array() not returning query results
which contain a single row
To whom it may concern:
I am using the perl DBI to query a remote Oracle 8 database. For most
circumstances everything works fine. However when I test using a query
that results in one returned row, method fetchrow_array() does not
return the row. I know the row exists because I feed the identical query
into SQL*Plus and it comes back with the expected row.
The preceeding prepare and execute methods come back clean. I have coded
'die "Fetchrow_array failed due to $DBI::errstr" if $DBI::err;'
immediately following the while loop driving the fetchrow_array() method
to be sure that no error is being raised. The script does not die with
this message.
Thanks in advance for your valuable assistance,
Dennis
[EMAIL PROTECTED]
