Oracle integration
Categories
Component ID
Component name
Component type
Maintenance status
Development status
Component security advisory coverage
Downloads
Component created
Component changed
Component body
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.
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.
Credits
D7 version: Marcus Anthony (therainmakor)
D6 version: Victor Kareh (vkareh)
