Illya:
Thanks for asking. In process of putting together a set of code to
demonstrate the problem, I found I was unable to re-create the problem. The
single row comes back as expected.
Must be something in my original script that is causing the problem. I now
have a small working script I can compare to my original script to help find
the problem on my end.
Thanks much,
Dennis
----- Original Message -----
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
To: "Dennis McCoy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, May 12, 2001 8:06 PM
Subject: RE: perl DBI method fetchrow_array() not returning query results
which contain a single row
> 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]
