APEX

Hi,

I am using APEX 19.1, DB 12c

I am creating a report using apex_item.select_list_from_query_xl.

My query is simple -

select col, apex_item.select_list_from_query_xl (

                        p\_idx => 1,

                        p\_value => null,

                        p\_item\_label => 'label',

                        p\_query => 'SELECT col as d, col as r from vp\_codes GROUP BY col',

                        p\_attributes => ' ',

                        p\_null\_text => '-- Select from the list-- '

                    ) cols from vp\_codes

However, I am getting

report error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

There are around 1350 rows in my table (1350 LOV items).

I have created a sample example on apex.oracle.com

ws - vpagmws

user - testuser

pwd - abcABC@123

app - 69143 - VP Test APP

page - 42 - Test LOV

Please suggest.

Thanks,

Veerendra.