oracle8.1.6 select title, revision_id from cr_revisions where item_id = :item_id and revision_id = content_item.get_latest_revision(:item_id) begin content_item.set_live_revision(:revision_id, 'live'); end; update acs_objects set last_modified = sysdate, modifying_user = :user_id, modifying_ip = :peeraddr where object_id = :item_id