update SALESORDER_DETAIL@DB_SQL set STATUS = '1' where NUMBER = 'P080818001' AND CODE = 'M07A00' and ORGANIZATION_ID = 111;----------------------------------------- 上面是修改语句,有何不妥吗?下面是配置语句之一,是否要改成“TWO_PHASE_COMMIT”?HS_FDS_TRANSACTION_MODEL = READ_ONLY
改成“TWO_PHASE_COMMIT”,会报以下错误;另外,需要配置 MSDTC 吗,UNIX 下面的MSDTC界面跟 Windows 的一样吗?ORA-02063:紧接着2 lines(源于DB_SQL)
现在想更新数据又出现问题,SQL如下:
UPDATE Cip_User@TGTEST A SET ("ID","Name","ShortName","Phone") = (select b.DEPARTMENT_ID,B.NAME,B.SHORTNAME,B.PHONE FROM CIP_CHANNEL B WHERE A."LoginName" = B.LOGNINAME) WHERE EXISTS (SELECT 1 FROM CIP_CHANNEL B WHERE A."LoginName" = B.LOGNINAME); 错误如下:
set STATUS = '1'
where NUMBER = 'P080818001'
AND CODE = 'M07A00'
and ORGANIZATION_ID = 111;-----------------------------------------
上面是修改语句,有何不妥吗?下面是配置语句之一,是否要改成“TWO_PHASE_COMMIT”?HS_FDS_TRANSACTION_MODEL = READ_ONLY
UPDATE Cip_User@TGTEST A SET ("ID","Name","ShortName","Phone")
= (select b.DEPARTMENT_ID,B.NAME,B.SHORTNAME,B.PHONE
FROM CIP_CHANNEL B WHERE A."LoginName" = B.LOGNINAME)
WHERE EXISTS (SELECT 1 FROM CIP_CHANNEL B WHERE A."LoginName" = B.LOGNINAME); 错误如下:
ORA-02070: 数据库 TGTEST 不支持此上下文中的 subqueries(子查询)为啥????