SQL> create or replace trigger ljb_abc_trigger
2before insert on ljb_abc for each row
3declare
4v_count number(5);
5begin
6select count(*) into v_count from ljb_abc;
7if (v_count>=10) then
8raise_application_error(-20000,'records were more than Max set,ple
9e insert to another table');
10end if;
11end;
12/
触发器已创建
SQL> select * from ljb_abc;
未选定行
SQL> declare i number;
2begin
3for i in 1..9 loop
4insert into ljb_abc values (i);
5end loop;
6end;
7/
declare i number;
*
第 1 行出现错误:
ORA-04045: 在重新编译/重新验证 ABC.BIN$vcqHYj+VRpWwRXBB2gwzFQ==$0 时出错
ORA-38301: 无法对回收站中的对象执行 DDL/DML
ORA-06512: 在 line 4