oracle 8.1.6

begin news.archive( item_id => :id, archive_date => :when); end;

begin news.make_permanent(:id); end;

begin news.del(:id); end;

select site_node.url(node_id) as url_stub from site_nodes where object_id=:package_id and rownum = 1

select * from ( select cn.*, ci.item_id, cr.content, cr.title, cr.mime_type, cr.description, to_char(o.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified from cr_news cn, cr_revisions cr, cr_items ci, acs_objects o where cn.package_id=:summary_context_id and cr.revision_id=cn.news_id and cn.news_id=o.object_id and cr.item_id=ci.item_id and cr.revision_id=ci.live_revision order by o.last_modified desc ) where rownum <= $limit
begin :1 := acs_rel.new(rel_type => 'relationship', object_id_one => :revision_id, object_id_two => :image_id, creation_user => :creation_user, creation_ip => :peeraddr); end;