create or replace procedure
delete_flightdetails (fdcode in number) as
begin
   delete from flightdetails where fd_code = fdcode ;
   if sql%notfound then
      raise_application_error(-20101,'Record does not exist');
      null;
   else
     commit;
   end if;
end;
/