WHILE v_notfound=0 DO set sqlStr='delete '||v_tname||'_'||to_char(current_date-90 days,'mm')||to_char(current_date-90 days,'dd');--  ...
显示全部WHILE v_notfound=0 DO
set sqlStr='delete '||v_tname||'_'||to_char(current_date-90 days,'mm')||to_char(current_date-90 days,'dd');--
execute immediate sqlstr ;--
set sqlstr='reorg table '||v_tname||'_'||to_char(current_date-90 days,'mm')||to_char(current_date-90 days,'dd');--
call SYSPROC.ADMIN_CMD(sqlstr);--
set v_notfound = 0;--
fetch fetchSeqCursor into v_tname, v_delete_col,v_delete_period,n_is_partition;--
end WHILE;--
close fetchSeqCursor;--
有可能是while 最后一步拼sql的时候拼的出现了问题,然后报了这个错,
SYSPROC.ADMIN_CMD 调用reorg 没有一点问题。兄好好调试下存储过程
收起