create or replace procedure
insert_flightdetails (
 c_routecode in varchar2, c_flightno in varchar2, c_mon in varchar2,
 c_tue       in varchar2, c_wed      in varchar2, c_thu in varchar2,
 c_fri       in varchar2, c_sat      in varchar2, c_sun in varchar2,
 c_acrcode1  in varchar2, c_acrcode2 in varchar2,
 c_city1     in varchar2, c_city2    in varchar2,
 c_city3     in varchar2, c_city4    in varchar2, c_city5 in varchar2,
 c_symbol    in varchar2, c_duration in varchar2 ) as
c_fdcode flightdetails.fd_code%type;
begin
 select nvl(max(fd_code),0) into c_fdcode from flightdetails;
 c_fdcode := c_fdcode + 1;
 insert into flightdetails values(
 c_fdcode,c_routecode,c_flightno,c_mon,c_tue,c_wed,c_thu,c_fri,c_sat,c_sun,
 c_acrcode1,c_acrcode2,c_city1,c_city2,c_city3,c_city4,c_city5,c_symbol,c_duration);
 commit;
end;
/