My Oracle Support Banner

Wrong number of columns selected in the LOV SQL query for {page name} (Doc ID 2377100.1)

Last updated on JULY 29, 2019

Applies to:

Oracle Application Express (APEX) - Version 5.1.3.00.05 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On Interactive Grid, if I select large number of columns(998 or 999) in the region source, it returns following error at runtime.

"Wrong number of columns selected in the LOV SQL query for {page name}. See examples for valid statements."

Contact your application administrator.
Technical Info (only visible for developers)

is_internal_error: true
apex_error_code: WWV_FLOW_PLUGIN_UTIL.LOV_SQL_WRONG_COLUMN_COUNT
component.type: APEX_APPLICATION_PAGE_REGIONS
component.id: 17776619169045691928
component.name: GRID_1226
error_backtrace:

----- PL/SQL Call Stack -----
object line object
handle number name
0xcde9f0438 942 package body APEX_050100.WWV_FLOW_ERROR
0xcde9f0438 1010 package body APEX_050100.WWV_FLOW_ERROR
0xcde9f0438 1402 package body APEX_050100.WWV_FLOW_ERROR
0xcc676a470 2117 package body APEX_050100.WWV_FLOW_PLUGIN_UTIL
0x1f635d2a8 3866 package body APEX_050100.WWV_FLOW_INTERACTIVE_GRID
0x1f635d2a8 5568 package body APEX_050100.WWV_FLOW_INTERACTIVE_GRID
0x1f635d2a8 5903 package body APEX_050100.WWV_FLOW_INTERACTIVE_GRID
0xcdea28708 2932 package body APEX_050100.WWV_FLOW_REGION_NATIVE
0xcdea8e488 2043 package body APEX_050100.WWV_FLOW_PLUGIN
0xcbda32c00 1396 package body APEX_050100.WWV_FLOW_DISP_PAGE_PLUGS
0xcbda32c00 1875 package body APEX_050100.WWV_FLOW_DISP_PAGE_PLUGS
0xcbda32c00 982 package body APEX_050100.WWV_FLOW_DISP_PAGE_PLUGS
0xccdd1fb58 2393 package body APEX_050100.WWV_FLOW_PAGE
0xccdd1fb58 2620 package body APEX_050100.WWV_FLOW_PAGE
0xcadcc2db8 4928 package body APEX_050100.WWV_FLOW
0x1f64819d0 173 procedure APEX_050100.F
0xcc62c4478 2 anonymous block

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.