如何解决ORA-01480: STR 赋值变量缺少空后缀错误？

[vison2001]

我写了一个JOB如下，本来时可以正常运行的，但加了一句（前面加了×××××××××的那句）就马上报错，不能保存了，请告知原因和解决方法！只看加了×××××××××的那句就行了，其他可以不必看。
update RM_BREAKFAST_TAB
set FLAG='1',STOP_FLAG='0'
where END_DATE<sysdate and STOP_FLAG='1';

DECLARE CURSOR CUR_BREAKFAST IS
select to_char(ENT_ROWID) as ENT_ROWID, ENT_NAME
from RM_BREAKFAST_TAB
where to_char(sysdate,'D') not like '7'
and to_char(sysdate,'D') not like '1'
and FLAG='1';

BEGIN
FOR breakfast IN CUR_BREAKFAST LOOP
delete RM_BREAKFAST where ENT_ROWID=breakfast.ENT_ROWID and trunc(CREATE_DATE)=trunc(sysdate);
×××××××××delete RM_BREAKFAST where ENT_ROWID=breakfast.ENT_ROWID and trunc(CREATE_DATE)=trunc(sysdate);
update OA_KEYS_TAB
set KEYMAXID=KEYMAXID+1
where ROW_ID='190';
insert into RM_BREAKFAST(ROW_ID)
select to_char(KEYMAXID+to_number(to_char(sysdate,'YYYYMM'))*10000000000)
from OA_KEYS_TAB
where ROW_ID='190';
if to_number(to_char(sysdate,'D'))=6 then
update RM_BREAKFAST
set ENT_ROWID=breakfast.ENT_ROWID,
ENT_NAME=breakfast.ENT_NAME,
CREATE_DATE=sysdate+3,
ENT_REPL_NAME=breakfast.ENT_NAME
where ROW_ID=(select MAX(ROW_ID) from RM_BREAKFAST);
ELSE
update RM_BREAKFAST
set ENT_ROWID=breakfast.ENT_ROWID,
ENT_NAME=breakfast.ENT_NAME,
CREATE_DATE=sysdate+1,
ENT_REPL_NAME=breakfast.ENT_NAME
where ROW_ID=(select MAX(ROW_ID) from RM_BREAKFAST);
end if;
END LOOP;
END;

[fita]

是不是文本太大了，试试改成其他语句报不报错，如果还报错就是文本太大了
可以把语句写到存储过程中，这里只写调用语句

[beckhambobo]

delete RM_BREAKFAST where ENT_ROWID=breakfast.ENT_ROWID and trunc(CREATE_DATE)=trunc(sysdate);
两个句话，即重复删除干什么，当然，删除不符合的记录，也不会报错.
或者语句后加一句commit;