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 (http://www.php.net/manual/en/ref.pdo-oci.php).
This module wraps PHP's OCI8 functions (http://www.php.net/manual/en/book.oci8.php) with Drupal's Database, DatabaseConnection, and DatabaseStatement classes, see oci8.database.inc for more information about classes defined by this 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.