create or replace procedure update_aircraft (a_code in varchar2 , a_number in varchar2, a_fircode in varchar2 , a_firclass in number, a_execode in varchar2 , a_execlass in number, a_ecocode in varchar2 , a_ecoclass in number) as begin update aircraft set acr_number = a_number, fir_code = a_fircode, fir_class = a_firclass, exe_code = a_execode, exe_class = a_execlass, eco_code = a_ecocode, eco_class = a_ecoclass where acr_code = a_code; commit; end; /