"Exception DBD,ORA-1795: max # of exprsns in list"

[system]

Reply based for ORACLE…

120×120 10.4 KB

Hi all, We have two different physical data bases and the corresponding universes. In the report , we have used two data providers pointing to these universes.They are linked by a unique number(object). In one of the queries(DP1) we have an inner query (in List ) which gets data from the other DP(DP2).Now if the result of the inner query is more than 1000 it is giving “LOV0001” error(might be because of MAX_INLIST is configured to 999). I tried increasing the MAX_INLIST Parameter in the Unive…

---

KhoushikTTT (BOB member since 2005-02-24)