I am a newbie in Oracle Apex so please excuse me for very naive questions. I was trying to use simple checkbox using LOV to create insert statement in the database table.
Apex version: 5.1
DB version : 12.1
Steps I followed
1. Created checkbox item based on LOV ( dynamic from a table )
2. On submit button, created a dynamic action which when true, executes a pl/sql block that inserts value in a table
Problem is that I am not getting selected checkbox values in APEX_APPLICATION.G_F01 as I thought it was supposed to ( my understanding based on google examples )
Can anyone point me a right direction ?
Debug log says
0.03254 | 0.00424 | ..Session ID 33840784999852 can be used | 4 | 8% |
0.03678 | 0.00009 | ...Setting session time_zone to -04:00 | 4 | 0% |
0.03687 | 0.00095 | ...Check for session expiration: | 4 | 2% |
0.03782 | 0.00066 | ......Validate item page affinity | 4 | 1% |
0.03847 | 0.00039 | ......Read Page Item values and validate protected items | 4 | 1% |
0.03886 | 0.00005 | .........Name=SELECT_DATABASES (id=18221404794302706), value=JS01PM:CREP01PB:CREP02PB, checksum= | 4 | 0% |
0.03891 | 0.00010 | Session State: Save "Items to Submit" | 4 | 0% |
0.03900 | 0.00078 | Session State: SELECT_DATABASES=>JS01PM:CREP01PB:CREP02PB <==== This is the value I am getting from checkbox which is correct | 4 | 1% |
0.03978 | 0.00010 | ... do not save: same value / password / no session | 4 | 0% |
0.03988 | 0.00174 | Run NATIVE/PLUGIN= request | 4 | 3% |
0.04162 | 0.00601 | ...Execute Statement: begin apex_debug.message('Value of array f01 at position'||APEX_APPLICATION.G_F01.count ); FOR i in 1 .. APEX_APPLICATION.G_F01.count LOOP INSERT INTO DR_DRILL_ACTIONS SELECT SYSDATE, APEX_APPLICATION.G_F01(i), 'PRECHECKS', 'STARTED', NULL FROM DUAL; commit ; END LOOP; end; | 4 | 12% |
0.04763 | 0.00381 | Value of array f01 at position 0 <== This is output of APEX_APPLICATION.G_F01.count which is 0. |
I think I am missing some very simple thing and there's surely a gap in my understanding. Can anyone point that to me ?
Thanks in advance.