I am getting the error: 
 
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
ARRAY(0x1024df4)
 
when I run the script below:
 
 
#!/usr/bin/perl -w
use strict; 
use DBI; 

my $dbh = DBI->connect($database, $username, $passwd) 
  or die "Can't connect to Oracle database: \n $DBI::errstr\n"; 

$dbh->{RaiseError} = 1;
#Set up your sql statement that you want to run in Oracle
my $sql=qq( select ctn from ctn_inv where rownum <11
);
 
#Prepare the SQL statement for running and it'll be stored in Oracle buffer
my $sth=$dbh->prepare($sql);
#Execute the SQL statememt
$sth->execute;

while( my $record= $sth->fetch())
{
 
 print "$record\n";
}

                
---------------------------------
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger

Reply via email to