Oracle driver

Installs: 
129
Open Bugs: 
22
Development Status: 
Seeking co-maintainer(s)
Maintenance fixes only

This is a driver that allows Drupal to use an Oracle Database (http://www.oracle.com/database/product_editions.html) instead of MySQL as the primary backend.

To create drupal nodes in a MySQL backend from Oracle tables you should use somenthing like http://drupal.org/project/migrate project, which is a robust data migration solution.

Eventually you can even store your site "files" directory inside Oracle with this module:
http://oranfs.sourceforge.net/ (let's say to have Oracle RMAN backup all your user data or

to search on it with the Oracle Text engine) or even use http://drupal.org/project/storage_api to implement an oracle backend for file storage.

A drupal_api PL/SQL package is also available to write/read drupal 6.x nodes and CCK fields, from PL/SQL procedures. You can write things like:

  declare
       v_node
  begin
               v_node:= drupal_api.new_node(p_title    => 'Lorem ipsum',
                 p_type   => 'my_news_ct',
                 p_body  => 'lorem......',
                 p_language => 'en');
               drupal_api.set_node_field(v_node,'publish_from_date', sysdate);
       for news in (select * from table(drupal_api.get_nodes_by_type('my_news_ct'))) loop
           if drupal_api.get_node_dat_field(news,'publish_from_date') < sysdate then
              .... do whaterver ....
           end if;
       end loop;
  end;

Development is sponsored by Plurimedia.

Usefull links

Releases: 
7.x-1.12
6.x-1.1
7.x-1.x-dev
6.x-1.x-dev
Release Dates: 
02/13/2012
01/27/2012
12/16/2013
10/01/2013