create or replace procedure insert_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 insert into aircraft values (a_code,a_number,a_fircode,a_firclass,a_execode,a_execlass,a_ecocode,a_ecoclass); commit; end; /