触发器出了问题,望各位给解决呀!!!!:(
错误提示:游标打开超出最大数.我还想问一下这个触发器会不会死循环,怎么解决?
CREATE OR REPLACE TRIGGER "SYSTEM"."ADD_MI_PRINX" BEFORE INSERT ON "USA" FOR EACH ROW Declare
maxprinx usa.mi_prinx%type;
temp usa.mi_prinx%type;
cursor mi_cursor is select max(mi_prinx) from usa;
begin
open mi_cursoe;
fetch mi_cursor into temp;
maxprinx := temp+1;
insert into usa (mi_prinx) values(maxprinx);
commit;
close mi_cursor;
end;