Hi all,
APEX 24.1 on database 19c
We have a page that is based on datadictionary view user_scheduler_jobs. We recently added a new job and since then the page errors out with ORA-06502.
From the apex debugger:
Error: ORA-06502: PL/SQL: numerieke fout of fout in waarde : tekenstringbuffer is te klein..
- Additional info:
- Display location:
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: false
- Common runtime error: false
- APEX error code:
- SQL code: -6502
- SQL error: ORA-06502: PL/SQL: numerieke fout of fout in waarde : tekenstringbuffer is te klein..
ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER", regel 9474
ORA-06512: in "APEX_240100.WWV_FLOW_UTILITIES", regel 8308
ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER", regel 630
ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER", regel 9067
- Backtrace: ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER", regel 9474
ORA-06512: in "APEX_240100.WWV_FLOW_UTILITIES", regel 8308
ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER", regel 630
ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER", regel 9067
ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER", regel 14415
- Statement:
- Component: APEX_APPLICATION_PAGE_REGIONS Overview Scheduler Jobs (50085146064012608)
When i leave out column job_action (varchar2(4000)) in the selection, the page runs fine.
A varchar2(4000) column should be no problem for APEX.
All i could find regarding this error on MOS was document id 1443722.1, but that dates from pre 24.1 date.
Does anyone know what could be possible causes that lead to this error?
Any tips/pointers/clues are much appreciated.
Thanks in advance!
Regards,
Hoek