开发人员在备库使用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