I have an inner query where it has to search through the list of IDs (using IN parameter). If the size of list of IDs is more than 1000, sql gives error of exceeding the maximum number of expressions in the list. I am using Spring JDBC.
My Query:
SELECT id, name, distance, type, FROM GLBL_NAME gname GLBL_DEF def WHERE gname.id = def.id and gname.OID in(2508, 1701, 4210, . . . . more than 1000)
above query is giving :
org.springframework.jdbc.B
adSqlGramm
arExceptio
n: StatementCallback; bad SQL grammar [SELECT id, name, distance, type, FROM GLBL_NAME gname GLBL_DEF def WHERE gname.id = def.id and gname.OID in(2508, 1701, 4210, . . . . more than 1000) nested exception is java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
Start Free Trial
