BEGIN
{
  $ENV{LD_LIBRARY_PATH} .= ":/users/oracle/product/9.2.0/lib";
  $ENV{ORACLE_HOME}    ||= "/users/oracle/product/9.2.0";
}

package MyDatabase::DBI;
use strict;

use base 'Class::DBI::Oracle';

# connect to the database.
MyDatabase::DBI->connection('dbi:Oracle:fred', 'wilma', 'barney');

# more code to follow etc...