Front page | perl.dbi.users |
Postings from February 2001
RE: DBI with DBD::Oracle Problem #2
Thread Previous
|
Thread Next
From:
P B
Date:
February 18, 2001 22:19
Subject:
RE: DBI with DBD::Oracle Problem #2
Message ID:
F100jtmPcTcMeYunH5d0001b199@hotmail.com
Okay, after some work on this, I'm getting this problem consistently on the
actual NT server. You're right, the error happens after the program runs --
during destruction. Results are returned, but the error is routinely
causing scripts -- CGI -- to crash, or giving other problems. The error is
(as before):
(in cleanup) Can't call method "FETCH" on an undefined value at
D:/Perl/
site/lib/Win32/TieRegistry.pm line 1486 during global destruction.
Is there a way to at least catch/throw this in a CGI and tell perl to ignore
it? Or... can give perl a flag to tell it to ignore it?
This time I'm on an NT 4.0 with active perl 5.6.1 (the most recent) and
updated DBD, DBI, etc.
No firewall or anything like that is up....
Suggestions greatly appreciated, as I need to get this up and working in a
couple of days.
>From: "Orekhova, Irina" <Irina_Orekhova@mcgraw-hill.com>
>To: "'P B'" <pcboutro@hotmail.com>
>CC: "'dbi-users@perl.org'" <dbi-users@perl.org>
>Subject: RE: DBI with DBD::Oracle Problem #2
>Date: Thu, 25 Jan 2001 13:15:17 -0500
>
>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:pcboutro@hotmail.com]
>Sent: Wednesday, January 24, 2001 4:04 AM
>To: dbi-users@isc.org
>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 dbi-users-request@isc.org with the subject line of:
>'unsubscribe'.
>----------------------------------------------------------------------------
>--
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Thread Previous
|
Thread Next