Issue with SELECT LIST LOV in Tabular Form

0
votes

I am facing issue with Select List LOV having values more than 450. enter image description here

It works fine when I limit the value by ROWNUM <= 400 or by using POP-UP LOV. I am trying to find a solution where I don't have to do any deployment or change app from back end.

1
oracle-apexapexoracle-apex-5oracle-apex-5.1
The error you posted doesn't seem to have anything to do with the description you provided. The number of options in a LOV has no relationship to the length of a variable being exceeded. My guess is that you have some process on your page that declares a variable that is too small and it happens that the longer values are eliminated when you include the rownum predicate. But without a reproducible test case, all we can do is guess at what might be going on. - Justin Cave
@JustinCave Even I was also in same picture but with DEBUG I saw the sql behind the LOV is getting failed. It took time to find this root cause and is almost un-predictable. I this Pop up LOV has its own session when clicked but Select List appears on screen for all rows in tabular form. - Anshul Ayushya
It seems there is a restriction with Select List but am not aware of. - Anshul Ayushya
@JustinCave please see link stackoverflow.com/questions/66669303/… - Anshul Ayushya
Can you reproduce the problem on apex.oracle.com? - Justin Cave

1 Answers

0
votes

I can re produce it the issue is happening when we have large values in Select List LOV. When I changed it to Pop up LOV it works fine.