We have migrated from Apex 19.2 to 23.2… Now on changing a record entry in an Interactive Grid and then saving it I got a yellow warning box in the upper right corner:
- ORA-01858: a non-numeric character was found where a numeric was expected
I know what this error message means but I don't know which column is causing this. I've enabled the Debug mode (Full Trace) in hope to see the created UPDATEstatement causing this error. I can see a related red entry in the Debugger:
Error: ORA-01858: a non-numeric character was found where a numeric was expected
- Additional info: ORA-01858: a non-numeric character was found where a numeric was expected
- Display location: ON_ERROR_PAGE
- Association type: REGION
- Item name:
- Region id: 67305742871960208
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: false
- Common runtime error: false
- APEX error code:
- SQL code: -1858
- SQL error: ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8912
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 1495
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8671
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8771
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8935
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1371
ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634
- Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8912
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 1495
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8671
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8771
ORA-06512: at "APEX_230200.WWV_FLOW_INTERACTIVE_GRID", line 8935
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1371
ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS", line 192
- Statement:
- Component: APEX_APPLICATION_PAGE_PROCESS Leafs - Save Interactive Grid Data (67319437944960284)
Okay, nice but not really helpful. I can't see the related item nor the SQL statement causing this issue. Tab “Errors” in Debug windows says “No data found” (no errors).
→ Any suggestions or ideas leading me to the error causing item(s), column(s) or executed UPDATE statement?