Oracle Application Express (MOSC)

MOSC Banner

Problems with APEX_ITEM.CHECKBOX

edited Jan 25, 2013 11:09AM in Oracle Application Express (MOSC) 7 commentsAnswered
I am trying to control the checkbox on a report in APEX.  Everything works perfectly until the list of checkbox entries exceeds 4000 characters.  I believe this is due to a limitation that varchar2 can only be 4000 max in an SQL. 

I pass the list of checked items into APEX_ITEM.CHECKBOX via an application variable called F118_CHECKBOX_LIST. However, I have also tried changing that to a separately defined variable of FCHECKBOX varchar2(30000).  That failed to work as well.

Example query for report:

select APEX_ITEM.CHECKBOX(1,
inv_key||','||inv_type_key,
'onchange="spCheckChange(this);"',
:F118_CHECKBOX_LIST,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center