execute immediate的有关问题

2012-04-16

execute immediate的问题SQL codeDECLAREsqltext varchar(500) month varchar(5)BEGINselect to_char(to

execute immediate的问题

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语句单独执行试试

热点排行

Bad Request.

oracle

execute immediate的有关问题