It is a refernce to an address_type.
-----Original Message-----
From: Joe Raube [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 8:57 AM
To: '[EMAIL PROTECTED]'
Subject: Re: DBI and DBD:: Oracle problem
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]
