Take a look at DBI. The connect and/or connect_cached methods create a connection to the database and return a handle that can be used with other DBI methods. The connection itself is very simple:

my $dbh = DBI->connect($data_source, $username, $auth, \%attr);
[download]

If you want to connect to an Oracle database, you'll also have to use DBD::Oracle;, which provides the drivers (see DBD::Oracle).

Please also look through some of the excellent posts in our Tutorials section, including:

• Before asking a database related question ...
• DBI recipes
• Reading from a database

Finally, there is http://dbi.perl.org and Programming the Perl DBI.

A good place to start would be with DBD::Oracle

Cheers,
Darren :)

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";

...
[download]

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,