请高手帮帮忙,oracle 动态SQL问题
declare
v_str varchar2(5000) ;
v_date date;
begin
v_date:=to_date('20080611','yyyymmdd');
v_str:='create table tb_375_d_fcf_zz_qd as
select serv_number,production_id from
masa375.TB_DW_PD_USER_FUNCTION_CUR where deal_date = :1 and production_id in (''BPA1'',''BPA16'',''BPA24'',''BPA25'',''BPA26'',''BPA231'',''BPA232'',''BPA233'',''BPA21'',''BPA117'',''BPA64'')' ;
execute immediate v_str using v_date;
end;
执行后报错
ERROR 位于第 1 行:
ORA-01027: bind variables not allowed for data definition operations
ORA-06512: at line 9
请高数指出问题所在,谢谢!