Oracle Driver
Drupal 7 will no longer be supported after January 5, 2025. Learn more and find resources for Drupal 7 sites
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; 