navicat 同一句 SQL 语句以前执行没问题，现在报 OCI_INVALID_HANDLE

This topic created in 2209 days ago, the information mentioned may be changed or developed.

一句 sql 执行 50 秒后报错 Error - OCI_INVALID_HANDLE
instantclient 应该是正常的因为执行其他 sql 语句没问题
这句 sql 以前也执行过没问题。

select AAA,BBB,CCC from TTT WHERE 
AAA IN ('X1','X2') AND 
DDD IN ('Y1','Y2','Y3','Y4') AND 
(
BBB BETWEEN to_date('2017-05-14 00:00:00','yyyy-mm-dd hh24:mi:ss') AND to_date('2017-05-18 00:00:00','yyyy-mm-dd hh24:mi:ss')
OR
BBB BETWEEN to_date('2018-03-30 00:00:00','yyyy-mm-dd hh24:mi:ss') AND to_date('2018-04-01 00:00:00','yyyy-mm-dd hh24:mi:ss')
OR
BBB BETWEEN to_date('2018-11-24 00:00:00','yyyy-mm-dd hh24:mi:ss') AND to_date('2018-11-25 00:00:00','yyyy-mm-dd hh24:mi:ss')
)
ORDER BY AAA,BBB

5 replies • 2020-05-06 17:49:06 +08:00