create or replace procedure
update_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
  update city set city_code    = c_citycode   ,
                  city_name    = c_cityname   , part_type  = c_parttype,
                  country_code = c_countrycode, gmt_time   = c_gmttime ,
                  city_addr1   = c_cityaddr1  , city_addr2 = c_cityaddr2,
                  city_addr3   = c_cityaddr3  , air_addr1  = c_airaddr1,
                  air_addr2    = c_airaddr2   , air_addr3  = c_airaddr3
  where short_name = c_shortname; 
  commit;
end;
/