create or replace procedure update_country(c_code in number,c_name in varchar2) as begin update country set country_name = c_name where country_code = c_code ; commit; end; /