无法修复错误:PL/SQL语句被忽略 [英] Can't fix Error: PL/SQL Statement ignored

问题描述

我刚刚开始使用触发器.尝试编译下一个代码片段时，错误会在日志中列出，如下所示:错误(2,3):PL/SQL:忽略了SQL语句"和错误(2,7):PL/SQL:ORA-00922 :选项缺失或无效". 我不明白这个问题.有人可以帮忙吗?

I've just started working with Triggers. While trying to compile the next code fragment errors are listed in the log, like so: "Error(2,3): PL/SQL: SQL Statement ignored" and "Error(2,7): PL/SQL: ORA-00922: missing or invalid option". I don't understand the problem. Can anybody help?

CREATE OR REPLACE TRIGGER CONT_VIG
BEFORE INSERT ON CONTRACTS
FOR EACH ROW
WHEN (OLD.CLIENTID = NEW.CLIENTID AND OLD.ENDDATE > NEW.STARTDATE)

BEGIN
SET (OLD.enddate = :NEW.startdate-1);    
END;  

推荐答案

您不能更改OLD值...

You can't change OLD value...

替换

SET (OLD.enddate = :NEW.startdate-1);    

例如:

:NEW.startdate := sysdate ;

(我删除SET的原因是看不到它的作用)

(I removed SET because I don't see the usefulness)

这篇关于无法修复错误:PL/SQL语句被忽略的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！