create or replace procedure
retrieve_country (code in varchar2, c_code out varchar2, c_name out varchar2) as
begin
   select country_code,country_name
   into c_code,c_name
   from country
   where country_code = code;
   exception when no_data_found then
   raise_application_error(-20101,'Record does not exist');
   null;
end;
/