I'm using apex 5.02 and 11g DB
I have a classic report with select of
SELECT empno, APEX_ITEM.POPUP_FROM_LOV(7,deptno,'LOV_DEPT') deptno
FROM emp.
I created a virtual column as a link to call another page
Name = DERIVED$01, type= LINK
target = Page in this application
Page 2
Set Items
Name = p2_deptno, value = #DEPTNO#
This results to
report error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
If I hard code the value to somelike 10 it would be ok also please note that in this manual tabular I need to all to add new row.
This means I need to access the value from the apex_item and not straight from the DB.
Thanks