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_source.new (
source_id => :source_id,
link => :link,
title => :title,
description => :description,
=> sysdate,
=> '0'
);
end
begin
:1 := na_source.new (
source_id => :source_id,
link => :link,
title => :title,
description => :description,
=> sysdate,
=> '0'
);
end
delete from na_items where creation_date + 60 < sysdate