oracle8.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