create or replace procedure
last_flightdetails (code in varchar2,
 c_fdcode    out number,
 c_routecode out varchar2, c_flightno out varchar2, c_mon out varchar2,
 c_tue       out varchar2, c_wed      out varchar2, c_thu out varchar2,
 c_fri       out varchar2, c_sat      out varchar2, c_sun out varchar2,
 c_acrcode1  out varchar2, c_acrcode2 out varchar2,
 c_city1     out varchar2, c_city2    out varchar2,
 c_city3     out varchar2, c_city4    out varchar2, c_city5 out varchar2,
 c_symbol    out varchar2, c_duration out varchar2 ) as
fdcode flightdetails.fd_code%type;
begin
   select max(fd_code) into fdcode from flightdetails where route_code = code;
   select fd_code,route_code,flight_no,mon,tue,wed,thu,fri,sat,sun,acr_code1,acr_code2,
          city1,city2,city3,city4,city5,symbol,duration into
          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
   from flightdetails
   where fd_code = fdcode and route_code = code;
   exception when no_data_found then
   raise_application_error(-20101,'Record does not exist');
   null;
end;
/