create or replace procedure
insert_flight (c_routecode   in varchar2, c_source  in varchar2,
               c_destination in varchar2, c_via     in varchar2,
               c_via2        in varchar2) as
begin
   insert into flight values(c_routecode,c_source,c_destination,c_via,c_via2);
   commit;
end;
/