What does your table look like? What is the data type of the 4th field? --- Naser Ali <[EMAIL PROTECTED]> wrote: > 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) > > >
__________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]