定义了如下触发器:
SQL> create or replace trigger roll_trig
2 after delete on student
3 for each row
4 begin
5 if :old.sno in('07008','07002')then
6 raise_application_error(-20000,'不能删除');
7 end if;
8 end;
9 /触发器已创建SQL> select * from student;SNO SNAME SSEX SAGE SDEPT
-------- ---------- ----- ---------- --------
07008 john male 18 ms
07002 mike male 18 ms
07003 jane fmale 23 is
07004 aaa fmale 18 cs
07005 bbb male 19 csSQL> delete from student where sno='07008';
delete from student where sno='07008'
*
第 1 行出现错误:
ORA-20000: 不能删除
ORA-06512: 在 "SYSTEM.ROLL_TRIG", line 3
ORA-04088: 触发器 'SYSTEM.ROLL_TRIG' 执行过程中出错
错在哪里?俺查不出来?帮帮忙吧
SQL> create or replace trigger roll_trig
2 after delete on student
3 for each row
4 begin
5 if :old.sno in('07008','07002')then
6 raise_application_error(-20000,'不能删除');
7 end if;
8 end;
9 /触发器已创建SQL> select * from student;SNO SNAME SSEX SAGE SDEPT
-------- ---------- ----- ---------- --------
07008 john male 18 ms
07002 mike male 18 ms
07003 jane fmale 23 is
07004 aaa fmale 18 cs
07005 bbb male 19 csSQL> delete from student where sno='07008';
delete from student where sno='07008'
*
第 1 行出现错误:
ORA-20000: 不能删除
ORA-06512: 在 "SYSTEM.ROLL_TRIG", line 3
ORA-04088: 触发器 'SYSTEM.ROLL_TRIG' 执行过程中出错
错在哪里?俺查不出来?帮帮忙吧
*
第 1 行出现错误:
ORA-20000: 不能删除
ORA-06512: 在 "SYSTEM.ROLL_TRIG", line 3
ORA-04088: 触发器 'SYSTEM.ROLL_TRIG' 执行过程中出错
这也是正常提示吗?