This content has been marked as final. Show 1 reply
LnTInfotech wrote:It is not possible. There is a 32K limit on the HTML generated for select list items. (As a type of report, tabular forms are also subject to the 32K limit on the size of a report row.)
I created a tabular form with two select lists (Queries are same for both the select list and results around 300 records in the SQL).
I am getting the following error:
ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
If I changed Select list to POP list, I am not getting error.
Please suggest how to user select list in this case.
In terms of usability 200 options is about the maximum size I would consider sensible for a select list ( and for select lists in tabular forms, much, much fewer!)
Use Popup Key LOVs.