create or replace trigger TRG_VT_BBS_BOARD_DELETE
before delete on vt_project
for each row
declare
-- local variables herebegin
delete vt_bbs_board where blockid=:old.projectid;
delete vt_bbs_boardmaster where blockid=:old.projectid;
exception
when others then
raise_application_error(-20000,'ERROR trg_pets_upper_pet_kind: ' || SQLERRM);end TRG_VT_BBS_BOARD_DELETE;当我只有一个删除项(delete vt_bbs_board where blockid=:old.projectid;)时没错误,但是加上delete vt_bbs_boardmaster where blockid=:old.projectid;这一下项,执行vt_project删除记录时就出现错误,是不是不能这样写呀?
before delete on vt_project
for each row
declare
-- local variables herebegin
delete vt_bbs_board where blockid=:old.projectid;
delete vt_bbs_boardmaster where blockid=:old.projectid;
exception
when others then
raise_application_error(-20000,'ERROR trg_pets_upper_pet_kind: ' || SQLERRM);end TRG_VT_BBS_BOARD_DELETE;当我只有一个删除项(delete vt_bbs_board where blockid=:old.projectid;)时没错误,但是加上delete vt_bbs_boardmaster where blockid=:old.projectid;这一下项,执行vt_project删除记录时就出现错误,是不是不能这样写呀?
vt_bbs_boardmaster 主键BLOCKID, MEMBERID
是不是要删除vt_bbs_boardmaster中的BLOCKID主键