出错现象:
15:14:50 Start Compiling object(s) ...
15:14:51 Executing ALTER TRIGGER output_everyday COMPILE ...
15:14:51 [3:11] PLS-00103: 出现符号 "IMMEDIATE" 当遇到下列之一时:
15:14:51 := . ( @ % ;
15:14:51 符号 ":= 在 "IMMEDIATE"\ 继续之前已插入.
15:14:51 Compilation complete - 1 error(s) found
15:14:51 End Compiling object(s)
15:14:50 Start Compiling object(s) ...
15:14:51 Executing ALTER TRIGGER output_everyday COMPILE ...
15:14:51 [3:11] PLS-00103: 出现符号 "IMMEDIATE" 当遇到下列之一时:
15:14:51 := . ( @ % ;
15:14:51 符号 ":= 在 "IMMEDIATE"\ 继续之前已插入.
15:14:51 Compilation complete - 1 error(s) found
15:14:51 End Compiling object(s)
num number;
BEGIN
execute immediate 'select count(*) from evr_lxl' into num;
dbms_output.put_line(num);
END;
因为我要每天建表,表名后跟着日期,建完后插入数据,所以想用动态sql。有啥方法解决吗?