oracle8.1.6 begin news.archive( item_id => :id, archive_date => :when); end; begin news.make_permanent(:id); end; begin news.delete(:id); end; select site_node.url(node_id) as url_stub from site_nodes where object_id=:package_id and rownum = 1