出现符号 "IF"在需要下列之一时

[iyishengyouni]

BEGIN
Update RSC_SYS_DAYPART_SETUP
Set DAYPART_NAME = #daypartName#,
FROMTIME = #fromtime#, TOTIME = #totime#,
DAYPART_TYPE = #daypartType#
Where DAYPART_ID = #daypartId#
IF sql%rowcount = 0 THEN
Insert Into RSC_SYS_DAYPART_SETUP (DAYPART_NAME,
FROMTIME, TOTIME, DAYPART_TYPE)
Values (#daypartName#, #fromtime#, #totime#,
#daypartType#);
END IF;
END;

[iyishengyouni]

求高手解析问题何解

[horizonlyhw]

Where DAYPART_ID = #daypartId#
这后面少了个分号

[iihero]

先试图更新值为DAYPART_ID = #daypartId#的那些行，如果没有符合条件的行，则插入一行数据。