Questions tagged [ora-01795]
4 questions
18
votes
7 answers
Java Oracle exception - "maximum number of expressions in a list is 1000"
I am passing a list of Strings to my query(SQL query written) to fetch the required data.
But I am getting this exception:
ora-01795 maximum number of expressions in a list is 1000
I checked that I have more than 1000 entries in the list passed…
Anand
- 20,708
- 48
- 131
- 198
5
votes
5 answers
Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000?
I am using java/hibernate/Oracle. i have a list with more than 3000 entries. if i pass whole list i get below exception.
Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
to solve the issue i am…
user1016403
- 12,151
- 35
- 108
- 137
2
votes
1 answer
ORA-01795: maximum number of expressions in a list is 1000 , how to split the string
How to split the following string?
A.x IN (changeList),
changeList has the following value, so that it makes the clause like this:
A.x IN (HEXTORAW('1E2956B9266F11DDA85810000000C959'),HEXTORAW
…
garuda
- 67
- 1
- 2
- 8
0
votes
1 answer
Oracle maximum number of expression issue
I have this query
@Query("SELECT b from BillInfoDetails b where b.masterAcctCode in :masterAccountList and b.msisdn in :msisdnList") ListfindAllByMsisdnAndMasterAcctList(@Param("masterAccountList")List masterAccountList,…
Sadi
- 1
- 2