oracle8.1.6 begin news.archive( item_id => :id, archive_date => :when); end; begin news.make_permanent(:id); end; begin news.del(:id); end; 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