Go to CPAN and get the module DBI, and DBD::Oracle. read the docs there regarding using them. DBI is an nice interface to various database (Database Independent Layer), and DBD::Oracle, working in conjunction with the DBI contains concerns specific to oracle databases.
note: i have never used DBD::Oracle, but have used other DBD 's