Hi All,
We are seeing this " ORA-01795: maximum number of expressions in a list is 1000 " Error ., while using the below query ... Could you please share your thoughts.
select * from scanner where id in (select objkey1 from objectusage where objectclassid='34' and usedate>'01 MAR 18' and usedate<='30 MAR 18')
This is the entire Hibernate query:
---------------------------------------------------
select customer0_.id as col_0_0_, customer0_.name as col_1_0_, customer0_.uniquename as col_2_0_, customer0_.billingaccountnumber as col_3_0_, customer0_.billingrtnumber as col_4_0_, scanner1_.modelnumber as col_5_0_,count(*) as col_6_0_ from eapp3141.org customer0_, eapp3141.scannerscanner1_ where customer0_.classid=22 and customer0_.id=scanner1_.customerid and customer0_.servicedbyid=? and customer0_.billingsystemname=? and customer0_.customersegment=? and (scanner1_.id in (select objectusag2_.objkey1 from eapp3141.objectusage objectusag2_ where objectusag2_.objectclassid=34 and object
usag2_.usedate>? and objectusag2_.usedate<=?)) group by customer0_.id , customer0_.name , customer0_.uniquename , customer0_.billingaccountnumber , customer0_.billingrtnumber , scanner1_.modelnumber order by customer0_.id
Thanks,