Query is associated with dblink table, and then there's sort of field behind the select, insert-CodePudding

As title,

 
INSERT INTO LATESTACTREPAY 
SELECT LOAN_UUID, RO, FACT_DATE FACT_SK_MONEY 
The FROM (SELECT a. OAN_UUID, 
ROW_NUMBER () OVER (PARTITION BY a. OAN_UUID ORDER BY C.F ACT_DATE DESC) AS RO, 
FACT_DATE, 
The SUM (FACT_SK_MONEY) FACT_SK_MONEY 
The FROM ENFO_EPM. QLC_TCONTRACT_LOAN @ ENFO A 
LEFT the JOIN ENFO_EPM. QLC_TINAPPLY @ ENFO B ON a. OAN_UUID=B.L OAN_UUID 
LEFT the JOIN ENFO_EAM. EAM_TINAPPLY_LEFT @ ENFO C ON B.I N_UUID=C.I N_UUID 
GROUP BY a. OAN_UUID FACT_DATE) 
WHERE RO=1

The above statement, only a sort of query field take out, don't complain, don't remove will ORA - 22992: can't use selecting from a remote table LOB locator
What reason is this? The great god

CodePudding user response:

The great god! Help!!!!!