create or replace procedure
update_citytime (
 ctcode    in number,   fdcode      in number,
 fromdate  in varchar2, todate      in varchar2,
 deptime1  in varchar2, deptime2    in varchar2,
 deptime3  in varchar2, deptime4    in varchar2,
 arrtime2  in varchar2, arrtime3    in varchar2,
 arrtime4  in varchar2, arrtime5    in varchar2,
 changeofflight in varchar2) as
row rowid;
begin
 update citytime
 set dep_time1 = deptime1, dep_time2 = deptime2,
     dep_time3 = deptime3, dep_time4 = deptime4,
     arr_time2 = arrtime2, arr_time3 = arrtime3,
     arr_time4 = arrtime4, arr_time5 = arrtime5,
     change_of_flight = changeofflight
 where ct_code = ctcode ;
 commit;
end;
/