sql - 执行此 sql 后不再从套接字读取数据

Question

为什么当我使用 SQL Developer 执行此 SQL 时，它说

No more data to read from socket

但是当我重新连接连接然后删除fetch next 5 rows only它执行完美？

当我在 Web 应用程序上执行此查询时也会发生这种情况，它会给出以下错误：

oci_execute(): ORA-03113: end-of-file on communication channel
Process ID: 4136
Session ID: 18
Serial number: 36957 

SELECT PO_ID,
       ENQ_ID,
       TITLE,
       SYS_BRKDWN_ID,
       TECH_HAND_USR_ID,
       PROJ_NO,
       SUPPL_NO,
       approver_usr_id,
       VER
FROM   S181 
WHERE  approver_usr_id ='EETEC'
and    reject_date is null
AND    po_hdr_biz.can_approve(po_id, enq_id, ver,'EETEC') = 1
AND    EXISTS (
  SELECT NULL
  FROM   po_approvals
  WHERE  po_approvals.po_id = s181.po_id
  AND    po_approvals.ver = s181.ver
  AND    po_approvals.init = 'EETEC'
  AND    po_approvals.init = s181.approver_usr_id
  AND    po_approvals.po_id IS NOT NULL
  AND    po_approvals.approve_date IS NULL
UNION
  SELECT NULL
  FROM   po_approvals
  WHERE  po_approvals.enq_id = s181.enq_id 
  AND    po_approvals.ver = s181.ver 
  AND    po_approvals.init = 'EETEC'
  AND    po_approvals.init = s181.approver_usr_id 
  AND    po_approvals.enq_id IS NOT NULL
  FETCH NEXT 5 ROWS ONLY
);

标签： sqloracleoracle12c