oracle 分页查询失败,oracle分页查询时提示错误Extracted SQL state class '42' from value '42000'，SQL语句在plsql里可以执行...

10:36:25.173 [main] DEBUG o.s.j.support.SQLErrorCodesFactory - Looking up default SQLErrorCodes for DataSource [{

CreateTime:"2016-06-28 10:36:23",

ActiveCount:1,

PoolingCount:2,

CreateCount:3,

DestroyCount:0,

CloseCount:2,

ConnectCount:3,

Connections:[

{ID:99857960, ConnectTime:"2016-06-28 10:36:23", UseCount:0, LastActiveTime:"2016-06-28 10:36:23"},

{ID:1128005413, ConnectTime:"2016-06-28 10:36:23", UseCount:2, LastActiveTime:"2016-06-28 10:36:25"", CachedStatementCount:2}

]

}

[

{

ID:99857960,

poolStatements:[

]

},

{

ID:1128005413,

poolStatements:[

{hitCount:0,sql:"select * from (select a.*, rownum n___row_id__ from (select * from bac001) a where rownum) where n___row_id__>=? " },

{hitCount:0,sql:"select count(0) rows from(select * from bac001) RES" }

]

}

]]

10:36:25.173 [main] DEBUG o.s.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource

10:36:25.174 [main] DEBUG o.s.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource

10:36:25.174 [main] DEBUG o.s.j.support.SQLErrorCodesFactory - Database product name cached for DataSource [com.alibaba.druid.pool.DruidDataSource@7900f3c9]: name is 'Oracle'

10:36:25.174 [main] DEBUG o.s.j.support.SQLErrorCodesFactory - SQL error codes for 'Oracle' found

10:36:25.174 [main] DEBUG o.s.j.s.SQLErrorCodeSQLExceptionTranslator - Unable to translate SQLException with Error code '923', will now try the fallback translator

10:36:25.175 [main] DEBUG o.s.j.s.SQLStateSQLExceptionTranslator - Extracted SQL state class '42' from value '42000'