MySQL Forums
Forum List  »  Perl

perl DBI urgent need help please help begging oracle dbi
Posted by: sumit arora
Date: February 13, 2008 12:12PM

hi i am trying to connect to an oracle database using dbi and i get this ::

Driver has not implemented the disconnect_all method. at /opt/perl/lib/site_perl/5.8.0/sun4-solaris/DBI.pm line 575
END failed--call queue aborted.


for all i know, the script was working earlier, but has suddenly stopped working.

i cannot take a trace or find the log since log4perl is not installed. i cannot install any cpan module.

need help:::this is what i am using for connectibng::

my $db = DBI->connect("dbi:Oracle:$oracle_sid", "$oracle_user", "$oracle_passwd")

$db->{RaiseError} = 1;
my $sth = $db->prepare("SELECT query here...");

$sth->execute()

while (my @row = $sth->fetchrow_array)
{
my $a = $row[0];
my $b = $row[1];

next unless $a;
next unless $b;

}
$db->disconnect;

Options: ReplyQuote


Subject
Written By
Posted
perl DBI urgent need help please help begging oracle dbi
February 13, 2008 12:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.