oracle8.1.6 begin update ttl_tickets set area_id = :area_id, type = :type, status = :status, deadline = :deadline_date, priority = :priority where ticket_id = :ticket_id; update acs_objects set last_modified = sysdate, modifying_user = :caller_id, modifying_ip = :caller_ip where object_id = :ticket_id; end;