写一个存储过程，通过传入参数的值作为条件，创建一张表有错误

[liujunyanjiayou]

create or replace procedure ljy_dm_product(
prod_id varchar2
)

v_prom_nbr varchar2(50);

--v_offer_id varchar(50);
begin
v_prod_id := prod_id;


create table ls_dm_product as
select a.row_id as row_id
from prod_id a
where a.last_upd > to_date('20180920000000', 'yyyymmddhh24miss')
and not exists(select 1 from sp_im_cx_prom_all_map b where a.row_id = b.row_id)
and a.prod_id = v_prod_id;

exception
when others then
null;
end;
end;