Hello,
Oracle 19c.
Apex release 21.2
I'm selecting data from a table including sid as checkbox.
select apex_item.checkbox2(1,sid) "check",
DBNAME,
EVENT_TIMESTAMP,
OS_USERNAME
from table1;
on this page I've a button which calls a "modal dialog" page which has a text field and a commit button with a dynamic action.
when commit is clicked I call this dynamic action .
the dynamic action is calling a PL*SQL as identification action "execute server-side action"
the PL*SQL code is as follows:
begin
for i in 1 .. APEX_APPLICATION.G_F01.COUNT loop
update rzadmin.audit_alert
set kommentare = :P6_NEW --> this is the field in the modal dialog page
where sid = to_number(APEX_APPLICATION.G_F01(i));
commit;
end loop;
commit;
end;
unfortnately the update is not working because no rows were updated.
it seems that that the checkbox has no value.
how can I check if the value of the checkbox is set ?
thanks in advance for your answers
regards
Chris