An error occurred when querying the database by pagination from Oracle 11g database

[gaoxingxs]

apache-drill version: 1.22.0 oracle version: 11g

The query will return an error when the SQL statement contains limit.

org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. 

Sql: SELECT *
FROM "APEX_030200"."WWV_FLOWS"
FETCH NEXT 10 ROWS ONLY
Fragment: 0:0

storage plugin:

{
  "type": "jdbc",
  "driver": "oracle.jdbc.OracleDriver",
  "url": "jdbc:oracle:thin:@//xxx.xxx.xxx.xxx:1521/orcl",
  "username": "xxx",
  "password": "xxx",
  "authMode": "SHARED_USER",
  "writerBatchSize": 10000,
  "enabled": true
}