This module is used to connect to Oracle databases using Drupal's familiar database functions and classes, such as oci8_db_query(), oci8_db_query_range(), $query->execute(), $query->fetchAll(), etc. This module will not replace MySQL in Drupal, only allow access to Oracle databases on sites that do not have the PHP PDO Oracle drivers install due to its non-production ready drivers (

This module wraps PHP's OCI8 functions ( with Drupal's Database, DatabaseConnection, and DatabaseStatement classes, see for more information about classes defined by this module.

Installing Module

Install module as usual in /sites/all/modules. Before enabling, you must define
at lease one database connection in settings.php as described below.

* Database connection settings for the oci8 module. These settings
* mimic Drupal's main $databases variable.
$conf['oci8'] = array(
  'databases' => array(
    'default' => array(
      'default' => array(
        'database' => 'DATABASE_NAME',
        'username' => 'DATABASE_USER_NAME',
        'password' => 'DATABASE_PASSWORD',
        'hosts' => array('HOST_A', 'HOST_B'),
        'port' => 'PORT_NUMBER',

Please Note About Drupal 6 & 7 Versions

The Drupal 6 version is from the original maintainer of this module and kept for historical purposes until he decides to remove it. The Drupal 7 version takes a new approach for this module and will be adding features as the module grows.


D7 version: Marcus Anthony (therainmakor)
D6 version: Victor Kareh (vkareh)

Project Information