oracle dblink ora-16000,使用DBLINK跨库查询遇到ORA-01861,ORA-02063错误 | 信春哥，系统稳，闭眼上线不回滚！...

开发人员在备库使用DB LINK跨库查询时遇到ORA-01861和ORA-02063错误。

SQL> with RST_WMS AS

2 -- T_WH_NO REP_NO REP_NUM WMS_NO F_WH_NO SY_RESOURCE SKU YQ_QTY QTY GB_LVL

3 (SELECT a.ERP单号 as REP_NO,

4 a.ERP行号 as REP_NUM,

5 a.WMS单号 as WH_NO,

6 a.WMS行号 as WMS_NUM,

7 a.目标仓库 as T_WH_NO,

8 a.来源仓库 as F_WH_NO,

9 a.货主 as SY_RESOURCE,

10 a.SKU as SKU,

11 '' as YQ_QTY,

12 a.在途数量 as QTY,

13 case

14 when b.lotatt08 = '00' then

15 'G'

16 ELSE

17 'B'

18 end GB_LVL

19 --to_date(A.日期)

20 FROM view_edi_erp_invonline@WMS a

21 left join doc_asn_details@WMS b

22 on a.WMS单号 = b.asnno

23 and a.WMS行号 = b.asnlineno

24 WHERE to_date(a.日期) = date '2016-06-27')

25 SELECT * FROM RST_WMS;

with RST_WMS AS