The error, you get, happens during destruction - when you disconnect from a
database, so it's not the reason why you don't receive your resultset. I
remember there was a discussion about this error before: it seems that it's
just a bug and you can ignore it (somebody correct me if I'm wrong).
Why you don't receive your data - that's another question. Are you sure that
your query returns a row?
Irina.
-----Original Message-----
From: P B [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 4:04 AM
To: [EMAIL PROTECTED]
Subject: DBI with DBD::Oracle Problem #2
First off, thanks to everybody who pointed out to me that Oracle client
software was required for DBD::Oracle operation. Thanks also for the
explanations on why!
Now, I'm still experiencing some problems at run time with even the simplest
scripts.
The code I'm using is:
================== start
use DBI;
<In here I define $connect_string, $user_name, $query, and $user_pass. The
program runs with these definitions on the actual server, just not on a
remote machine.>
$dbh = DBI->connect($connect_string,$user_name,$user_pass) or die "Couldn't
connect! $DBI::errstr\n";
$query_sth = $dbh->prepare($query);
$query_sth->execute();
while (my @row = $query_sth->fetchrow_array) {
print @row;
}
$query_sth->finish();
$dbh->disconnect();
================= end
The query should return a single row, but instead gives the error message:
================= start
6047 (in cleanup) Can't call method "FETCH" on an undefined value at
E:/apps/
Perl/site/lib/Win32/TieRegistry.pm line 1486 during global destruction.
================== end
That file does indeed exist and line 1486 is:
my $unload= $self->{UNLOADME};
In the sub DESTROY.
>From the net-traffic I'm seeing, it appears that my PERL programming is
indeed doing some talking over the net. I haven't delved into that in more
detail yet.
I'm running ActivePerl build 623 (perl 5.6.0) under win98 on the client and
oracle 8i on NT 4.0 on the server.
Suggestions, ideas, criticisms appreciated!
Paul
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
----------------------------------------------------------------------------
--
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit:
http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web
page,
please send mail to [EMAIL PROTECTED] with the subject line of:
'unsubscribe'.
----------------------------------------------------------------------------
--
