oracle8.1.6 update ec_orders set order_state='void', reason_for_void=:reason_for_void, voided_by=:customer_service_rep, voided_date=sysdate where order_id=:order_id declare begin ec_reinst_gift_cert_on_order(:order_id); end;