CREATE OR REPLACE PROCEDURE getcountrypop (ccode country.code%TYPE)
IS
  c country%ROWTYPE;
  BEGIN
  execute immediate 'select * from country where code= :1'
    into c
    using ccode;
  dbms_output.put_line(c.population);
  END;
/
execute getcountrypop('CH');
