oracle 带参存储过程

create or replace procedure p(date_year in number)
is
  
begin　　

execute immediate '  select .......where .....= '||date_year||';

end p;