create or replace procedure
insert_city (c_citycode    in varchar2, c_cityname  in varchar2,
             c_shortname   in varchar2, c_parttype  in varchar2,
             c_countrycode in varchar2, c_gmttime   in varchar2,
             c_cityaddr1   in varchar2, c_cityaddr2 in varchar2,
             c_cityaddr3   in varchar2, c_airaddr1  in varchar2,
             c_airaddr2    in varchar2, c_airaddr3  in varchar2 ) as
begin
   insert into city values(
        c_citycode,c_cityname,c_shortname,c_parttype,c_countrycode,
        c_gmttime,c_cityaddr1,c_cityaddr2,c_cityaddr3,c_airaddr1,
        c_airaddr2,c_airaddr3);
   commit;
end;
/