Line: 81
Text: MERGE INTO SvcOrderProfit
Error: PL/SQL: SQL Statement ignored
Line: 81
Text: MERGE INTO SvcOrderProfit
用merge into 的时候提示
REF :http://www.cnblogs.com/dongsheng/p/4384754.html
问题代码:
WHEN MATCHED THEN
UPDATE
SET IncomeRMB = pos_2,
CostRMB = pos_3;/*,
v_dIncomeUSDFee = pos_4,
v_dIncomeUSDAccount = pos_5,
v_dlCostUSDFee = pos_6,
v_dlCostUSDAccount = pos_7,
v_dIncomeRMBSales = pos_8,
v_dCostRMBSales = pos_9,
ROOT CAUSE 本来左边应该是表名,从SQL 转过来的时候却弄成了变量。所以报错
:
solution :
表字段的保留, 非表字段的SELECT INTO 到变量里面:
SELECT NVL((SELECT SUM(SvcOrderFee.NoTaxFeeAmount)
FROM SvcOrderFee
WHERE SvcOrderFee.CurrencyType = 0
AND SvcOrderFee.CreditDebitType = 0
AND (SvcOrderFee.AccountType = 2 OR
SvcOrderFee.AccountType = 3)
AND SvcOrderFee.OrderBillID = v_lOrderBillID),
0)
INTO v_dCostRMBSales
FROM DUAL;