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)


Reply via email to