oracle8.1.6 update ec_sale_prices set sale_ends=sysdate, last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:peeraddr where sale_price_id=:sale_price_id