oracle通信通道的文件结尾_oracle里执行full join 报通信通道的文件结尾问题

oracle10G里执行fulljoin语句报通信通道的文件结尾问题，全部语句在下面：SELECT*FROM(SELECTNC.DATE_MONTHASDATE_MONTHN,NC.FLOWASFLOWN,SUM(WEIGHT)ASSUMNFROMPDA3A_CSM_USER.V_CSM...

oracle 10G里执行full join语句报通信通道的文件结尾问题，全部语句在下面：

SELECT * FROM

(SELECT NC.DATE_MONTH AS DATE_MONTHN ,NC.FLOW AS FLOWN,SUM(WEIGHT) AS SUMN FROM PDA3A_CSM_USER.V_CSM_SQUAN NC

WHERE NC.FLOW LIKE '内贸出口' AND CARGO_TYPE LIKE '钢材' AND NC.DATE_YEAR like '%2015%' AND NC.CARGO_OWNER IN

(SELECT CLIENTQM FROM T_CUSTOMER_CLIENT WHERE CUSTOMER_NAME LIKE '客户1')

GROUP BY NC.DATE_MONTH,NC.FLOW) NMCK

FULL OUTER JOIN

(SELECT WC.DATE_MONTH AS DATE_MONTHW ,WC.FLOW AS FLOWW,SUM(WEIGHT) AS SUMW

FROM PDA3A_CSM_USER.V_CSM_SQUAN WC

WHERE WC.FLOW LIKE '外贸出口' AND CARGO_TYPE LIKE '钢材' AND WC.CARGO_OWNER IN (SELECT CLIENTQM FROM T_CUSTOMER_CLIENT WHERE CUSTOMER_NAME LIKE '客户1')

AND WC.DATE_YEAR like '%2015%' GROUP BY WC.DATE_MONTH,WC.FLOW) WMCK

ON DATE_MONTHN=DATE_MONTHW

ORDER BY DATE_MONTHN,DATE_MONTHW ASC

PS:在本地oracle 11G上跑是没问题的，在连外部服务的10G上跑出问题，而且只有full join出问题，其他的join也是没问题的

展开