就是删除表TTG_Account一条记录的时候,删除表TTG_Customer对应的记录
现在问题是TTG_Customer没有对应的记录时要报错,说数据没有找到,编译已经通过了的Create Or Replace Trigger TR_TTG_Account_Delete_Customer
After Delete
ON TTG_Account
FOR EACH ROW
DECLARE
v_CustomerID number(10,0);
Begin
select CustomerID into v_CustomerID from TTG_Customer where CustomerNO=:OLD.AccountID;
IF v_CustomerID is not null THEN
delete from TTG_Customer where CustomerNo=:OLD.AccountID;
END IF;End TR_TTG_Account_Delete_Customer;
现在问题是TTG_Customer没有对应的记录时要报错,说数据没有找到,编译已经通过了的Create Or Replace Trigger TR_TTG_Account_Delete_Customer
After Delete
ON TTG_Account
FOR EACH ROW
DECLARE
v_CustomerID number(10,0);
Begin
select CustomerID into v_CustomerID from TTG_Customer where CustomerNO=:OLD.AccountID;
IF v_CustomerID is not null THEN
delete from TTG_Customer where CustomerNo=:OLD.AccountID;
END IF;End TR_TTG_Account_Delete_Customer;
select CustomerID into v_CustomerID from TTG_Customer where CustomerNO=:OLD.AccountID;
IF v_CustomerID is not null THEN
delete from TTG_Customer where CustomerNo=:OLD.AccountID;
END IF;不能这么判断的,要取出记录条数来判断记录是否存在