create or replace procedure
update_flight (c_routecode   in varchar2  , c_source  in varchar2,
               c_destination in varchar2  , c_via     in varchar2,
               c_via2        in varchar2) as
begin
   update flight 
   set source = c_source,destination = c_destination, via = c_via , via2 = c_via2
   where route_code = c_routecode;
   commit;
end;
/