oracle8.1.6 update ec_gift_certificates set expires=sysdate, last_modified=sysdate, last_modifying_user=:customer_service_rep, modified_ip_address= :address where gift_certificate_id=:gift_certificate_id