这是包部分:
CREATE OR REPLACE PACKAGE sectionupdatedata AS
type ridArray is TABLE OF rowid INDEX BY BINARY_INTEGER; newRows ridArray;
empty ridArray;END sectionupdatedata;
/
这是触发器:
CREATE OR REPLACE TRIGGER T_R_SECTION_UPDATE AFTER UPDATE OF completed ON SECTION FOR EACH ROW
BEGIN
sectionupdatedata.newRows(sectionupdatedata.newRows.count+1) :=:new.rowid; --这里有问题
END t_r_section_update;
/
sectionupdatedata.newRows(sectionupdatedata.newRows.count+1) :=:new.rowid;这句有问题,赋值不进去,不知道怎么错了,谢谢
CREATE OR REPLACE PACKAGE sectionupdatedata AS
type ridArray is TABLE OF rowid INDEX BY BINARY_INTEGER; newRows ridArray;
empty ridArray;END sectionupdatedata;
/
这是触发器:
CREATE OR REPLACE TRIGGER T_R_SECTION_UPDATE AFTER UPDATE OF completed ON SECTION FOR EACH ROW
BEGIN
sectionupdatedata.newRows(sectionupdatedata.newRows.count+1) :=:new.rowid; --这里有问题
END t_r_section_update;
/
sectionupdatedata.newRows(sectionupdatedata.newRows.count+1) :=:new.rowid;这句有问题,赋值不进去,不知道怎么错了,谢谢
若表有主键的话,当然有主键了