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