U have this program which connects to an Oracle 8i database but I get the
following error message. Can anyone help please,
=========================================
#!/usr/bin/perl -w
#
use DBI; # Load the DBI module
use DBD::Oracle;
### Perform the connection using the Oracle driver
my $dbh = DBI->connect ( 'dbi:Oracle:db01', 'user1', 'user1' )
or die "Can't connect to the database: $DBI::errstr\n";
### Prepare a SQL statement for execution
my $sth = $dbh->prepare( "SELECT * FROM student" )
or die "Can't prepare SQL statement: $DBI::errstr\n";
### Execute the statement in the database
$sth->execute
or die "Can't execute SQL statement: $DBI::errstr\n";
### Retrieve the returned rows of data
my @row;
while ( @row = $sth->fetchrow_array( ) ) {
print "Row: @row\n";
}
warn "Data fetching terminated early by error: $DBI::errstr\n"
if $DBI::err;
### Disconnect from the database
$dbh->disconnect
or warn "Error disconnecting: $DBI::errstr\n";
exit;
==========================================
Field 4 has an Oracle type (110) which is not explicitly supported at
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBD/Oracle..
Segmentation Fault(coredump)