create or replace procedure
insert_citytime (
 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
ctcode citytime.ct_code%type;
begin
 select nvl(max(ct_code),0) into ctcode from citytime;
 ctcode := ctcode + 1;
 insert into citytime values(
 ctcode,fdcode,fromdate,todate,deptime1,deptime2,deptime3,deptime4,
 arrtime2,arrtime3,arrtime4,arrtime5,changeofflight);
 commit;
end;
/