There is a Tabular form which contains a column of type: SELECT LIST for which LOV type is “SQL Query”
SQL Query:
select REPORT_TYPE d, REPORT_TYPE r
from CFG_report_type
WHERE TRACKER_ID IN (
SELECT TRACKER_ID
FROM CFG_PROTOCOL
WHERE id = (select PROTOCOL_ID from CASE where ID = :P42_ID))
order by id asc;
In very rare scenario it shows rows in the application with most of the times it shows below error:
report error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The SQL Query has total number of rows as 438. In development we tested and it works for less number such as 300, 310 but this number is no specific.
Another solution is to change the Column type to Pop up LOV.
Need Assistance: We need a solution where it is clear that SELECT LIST is restricted to particular number of rows. We are trying to find the solution to root cause if that is possible without a release of application so that we don’t have to neither change the Column type to Pop up LOV nor delete rows from LOV.
We are having this issue in APEX v4.2 and APEX v19.1.