create or replace procedure
update_cityperson (
               c_shortname in varchar2, c_contactperson  in varchar2,
	    	   c_extnum    in varchar2, c_cityphone      in varchar2,
	    	   c_airphone  in varchar2, c_faxnum         in varchar2 ) as
row rowid;
begin
   update cityperson set ext_num = c_extnum , city_phone = c_cityphone,
   air_phone = c_airphone, fax_num = c_faxnum
   where short_name = c_shortname and contact_person = c_contactperson;
   commit;
end;
/