请教:创建触发器成功,但执行插入时出错
CREATE OR REPLACE TRIGGER Insert_comments
AFTER insert ON comments
FOR EACH ROW
DECLARE
v_no NUMBER;
BEGIN
v_no:=:new.artitleID;
Update artitles set replyNum=replyNum+1 where artitles. artitleID =v_no;
END Insert_comments;
执行
insert into comments (COMID, COMMENTCONTENT, USERID, COMMENTTIME, ARTITLEID)
values (9, '扫描端口', 10, to_date('29-12-2010', 'dd-mm-yyyy'), 8);时,出错
出错
insert into comments (COMID, COMMENTCONTENT, USERID, COMMENTTIME, ARTITLEID)
*
第 1 行出现错误:
ORA-04098: 触发器 'SYSTEM.TU_ARTITLES' 无效且未通过重新验证 ORA-06512: 在
"SYSTEM.INSERT_COMMENTS", line 5
ORA-04088: 触发器 'SYSTEM.INSERT_COMMENTS' 执行过程中出错