RE: Trying to set up DBI for oracle

Ben Edwards wrote:
> I am trying to set up DBI Oracle stuff on a couple of boxes. One is
> Ubuntu Feiesty and the other is running SunOS 5.8.
>=20
> I have been using the following test script.
>=20
> #!/usr/bin/perl
> use DBI;
> $dbh =3D DBI->connect( "dbi:Oracle:gen3", "user", "pass" );
>=20
> Linux
> -------
> I get:
> install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC

You need to install DBD::Oracle with /usr/bin/perl. Download
DBD::Oracle from CPAN and follow the instructions in the README.

> SunOS
> ----------
> I get:
> install_driver(Oracle) failed: Can't load
>
'/opt/local/perl/5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto /DBD/Oracle/
Oracle.so'
> for module DBD::Oracle: ld.so.1: db.pl: fatal: libclntsh.so.8.0: open
> failed: No such file or directory at

Your DBD::Oracle can't find the Oracle client libraries. You probably
just need to set LD_LIBRARY_PATH to include $ORACLE_HOME/lib.

- Philip