oracle 8.1.6
begin :1 := na_source.new ( source_id => :source_id, package_id => :package_id, feed_url => :feed_url, link => :link, title => :title, description => :description, creation_user => :owner_id, creation_ip => :creation_ip ); end;
begin :1 := na_item.new ( source_id => :source_id, link => :link, title => :title, description => :description, creation_date => sysdate, deleted_p => '0' ); end;
begin :1 := na_item.new ( source_id => :source_id, link => :link, title => :title, description => :description, creation_date => sysdate, deleted_p => '0' ); end;
delete from na_items where creation_date + 60 < sysdate
update na_sources set link = :link, title = :title, description = :description, updates = (updates + 1), last_scanned = sysdate, last_modified = :last_modified where source_id = :source_id
select q.* from ( select deleted_p, item_id, i.title as item_title, i.description as item_description from na_sources s, na_items i where owner_id = :owner_id and s.source_id = i.source_id and i.$identifier = :$identifier and feed_url = :feed_url order by item_id ) q where rownum = 1