create or replace procedure
update_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, c_fdcode in number) as
begin
   update flightdetails set flight_no = c_flightno,
   mon = c_mon, tue = c_tue, wed = c_wed, thu = c_thu, fri = c_fri,
   sat = c_sat, sun = c_sun, acr_code1 = c_acrcode1, acr_code2 = c_acrcode2,
   city1 = c_city1, city2 = c_city2, city3 = c_city3, city4 = c_city4,
   city5 = c_city5, symbol = c_symbol, duration = c_duration 
   where fd_code = c_fdcode;
   if sql%notfound then
      raise_application_error(-20101,'Record does not exist');
      null;
   else
      commit;
   end if;
end;
/