create or replace procedure 
update_duration (d_code in number,f_date in date,t_date in date) as
begin
   update duration
   set from_date = f_date , to_date = t_date 
   where duration_code = d_code ;
   commit;
end;
/