CREATE OR REPLACE PROCEDURE sp (cname City.name%TYPE)
IS BEGIN declare cty city%ROWTYPE;
 BEGIN
 execute immediate 'select * from city where name= :1'
   into cty
   using cname;
 dbms_output.put_line(cty.population);
 END; END;
/
execute sp('Berlin');
