Forum Stats

  • 3,872,114 Users
  • 2,266,381 Discussions
  • 7,911,051 Comments

Discussions

Ajax Error after setting Highlight on columns in Interactive Grid

user1.0
user1.0 Member Posts: 98 Red Ribbon
edited Jul 26, 2022 10:02PM in APEX Discussions

Apex Version 19.2.0.00.18

I added some highlights to several columns using the Tools-Action Menu-Format-Highlight built in. 4 of the columns I'm highlighting are dates using the date picker. The value is not required.

When I exited and returned to the page I got this list of errors:

  • ora_sqlerrm: ORA-01840: input value not long enough for date format ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 992 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1212 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1212 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 4255 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 3460 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_API", line 197 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_API", line 423 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 1811 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 3421 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 4079 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 5907 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 6277 ORA-06512: at "APEX_190200.WWV_FLOW_REGION_NATIVE", line 2391 ORA-06512: at "APEX_190200.WWV_FLOW_PLUGIN", line 2212 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1397 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1881 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1193 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1868 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1193 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1868 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 977


As a quick test I set the server side to Never for the grid and the page displayed without error. Before adding the highlights, the page rendered as expected.

Is this a bug?

If I temporarily removed the date columns from the query in the grid, saved it and put them back the error went away - as did the highlight on those columns (which made sense).

Tagged: