maximum items in multivalue parameter
1 Topic
Maximum Items in Multivalue parameter
Hi, We have a paginated report. It has 2 parameter. One parameter is multivalue, where we can enter text values. Each Items is of size 10 char long. Requirment is, we have to enter max 3000 to 4000 items to the multi value parameter. here we have 2 issues, 1, In the query, we are retrieving values using 'IN ' clause. the IN clause has the restriction of 1000 items in Oracle. 2, Is it possible to send 3000*11 char to Back end. Do we have restrictions of max size of the parameter vlaue send to Back end? like I can send all 3000 id to backend as procedure input parameter.. Thanks in advance SobhaSolved1.9KViews0likes4Comments