Hello,
I am new to Apex. I created two DB tables linked with FK. Each table has one data row. I created an application with two pages - one for each table. The first one I can open, the second gives me an error - ORA-06502: PL/SQL: numeric or value error: NULL index table key value
What can be a reason to get this error on read?
this is the full error:
Technical Info (only available for developers)
- is_internal_error: true
- apex_error_code: APEX.REGION.UNHANDLED_ERROR
- ora_sqlcode: -6502
- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: NULL index table key valueORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1999 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706 ORA-06512: at "APEX_230200.WWV_FLOW_NATIVE_ITEM", line 2986 ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2100 ORA-06502: PL/SQL: numeric or value error: NULL index table key value ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 30 ORA-06512: at "APEX_230200.WWV_FLOW_NATIVE_ITEM", line 2941 ORA-06512: at "APEX_230200.WWV_FLOW_NATIVE_ITEM", line 8511 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 2711 ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 6790 ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 7012 ORA-06512: at "APEX_230200.WWV_FLOW_REGION_NATIVE", line 2513 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3164 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1106 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1635 ORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1947
- component.type: APEX_APPLICATION_PAGE_REGIONS
- component.id: 11762245741936332964
- component.name: Mentees
- error_backtrace:ORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1999 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706 ORA-06512: at "APEX_230200.WWV_FLOW_NATIVE_ITEM", line 2986 ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2100 ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 30 ORA-06512: at "APEX_230200.WWV_FLOW_NATIVE_ITEM", line 2941 ORA-06512: at "APEX_230200.WWV_FLOW_NATIVE_ITEM", line 8511 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 2711 ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 6790 ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 7012 ORA-06512: at "APEX_230200.WWV_FLOW_REGION_NATIVE", line 2513 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3164 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1106 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1635 ORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1947