DECLARE
sqltext varchar(500); month varchar(5);
BEGIN
select to_char(to_char((trunc(sysdate, 'mm')- interval '2' month),'mm'), '09') into month from dual;
sqltext:='truncate table XPrice_SRChannelHis_'||month||' drop storage';
dbms_output.put_line (sqltext);
execute immediate sqltext;
end;
ORA-03291: ??????? - ?? STORAGE ???
ORA-06512: ? line 8
输出的SQL语句单独执行试试