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
- http://inode.me/tutorials/how-to-drupal-7-oracle-xe-install
- http://drupal.org/node/1298536#comment-5083830
Downloads
Recommended releases
Development releases
Project Information
- Maintenance status: Actively maintained
- Development status: Under active development
- Module categories: Administration, Database Drivers
- Reported installs: 116 sites currently report using this module. View usage statistics.
- Downloads: 7,339
- Last modified: January 27, 2012
