The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > High Level Programming
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 02-13-2008
poggendroff poggendroff is offline
Registered User
  
 

Join Date: Feb 2008
Posts: 2
Angry perl dbi to oracle getting disconnect_all for oracle dbi help

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;