创建触发器时出现 PLS-00049: 错误的赋值变量
发布网友
发布时间：2022-04-23 12:58
共1个回答
热心网友
时间：2023-10-14 12:01
ORACLE 没玩过，不过旧值应该不是这样的，写个SQL的代码来你改下
delete from DeliveryMaster where DeliveryMaster.PurchaseID in (select PurchaseID from :old where PurchaseID= :old.PurchaseID)
二、delete from DeliveryMaster join old
on DeliveryMaster.PurchaseID= :old.PurchaseID;
试下
热心网友
时间：2023-10-14 12:01
ORACLE 没玩过，不过旧值应该不是这样的，写个SQL的代码来你改下
delete from DeliveryMaster where DeliveryMaster.PurchaseID in (select PurchaseID from :old where PurchaseID= :old.PurchaseID)
二、delete from DeliveryMaster join old
on DeliveryMaster.PurchaseID= :old.PurchaseID;
试下
