帮忙查看语法错误,从sql server转oracle,很多概念不一致
if not exists(select * from TSend, dual where FIsActive = 1 and FToTime > = sysdate and Ftype = 2) then
--一分钟后返回一条错误信息
insert into xujp_96345_send_record(tele_num, content, flag_send)
select SEND_DEST, '当前没有可以投票的活动 ', -1 from dual;
commit;
return;
end if;
commit;不加也是这样, 把return 改成exit 也是这样。
请多多指点,谢谢
这条语句,编译通不过
Compilation errors for PROCEDURE JIAJIE.CMPP_PROC
Error: PLS-00103: 出现符号 "; "在需要下列之一时:
;
符号 ";在 "; " 继续之前已插入。
Line: 29
Text: end if;
------解决方案--------------------; and ; are different.