in reply to connecting to oracle
Hi,
Remember that you must have installed the oracle libs in order to compile the DBD::Oracle module.
And when using the module, if it don't work, normally it's because you need to set the ORACLE_HOME environment variable, e.g:
use DBI; $ENV{ORACLE_HOME} = '/usr/local/oracle/OraHome_1'; # Database connection data my $dsn = "DBI:Oracle:host=$host;sid=$sid"; my $user = 'luser'; my $password = 's3c3t'; my $dbh = DBI->connect($dsn, $user, $password) or die "Can't connect: $DBI::errstr"; ...
If the Oracle database is an old version and you don't find anywhere the Oracle libs, to compile the DBD::Oracle, you can go with the Java JDBC via JDBC, of course you need the .jar file containing the Java JDBC, but this is very simple to get.
PS: By the way, RTFM
Regards,
|
|---|