Advertising sustains the DA. Ads are hidden for members. Join today

Contributed modules for Drupal 7

Oracle Driver

Drupal 7 will no longer be supported after January 5, 2025. Learn more and find resources for Drupal 7 sites

This guide has not yet been reviewed by Contributed modules for Drupal 7 maintainer(s) and added to the menu.

A drupal_api PL/SQL package is also available to write/read Drupal 6.x/7.x nodes / 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; 

Tags

Guide maintainers

bohart's picture