CREATE OR REPLACE PROCEDURE find_area_pop
(p_country_id IN wf_countries.country_id%TYPE,
p_country_name OUT wf_countries.country_name%TYPE,
p_population OUT wf_countries.population%TYPE) IS
BEGIN
SELECT country_name, population INTO p_country_name, p_population
FROM wf_countries
WHERE country_id = p_country_id;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE ('There was no data matching your search');
END find_area_pop;
