- SQL code
DECLAREsqltext varchar(500); month varchar(5);BEGINselect 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
------解决方案--------------------
你把sqltext打印出来,然后把这打印出的语句去执行,看有没有错?
------解决方案--------------------
dbms_output.put_line (sqltext);
输出的SQL语句单独执行试试