update table when checkbox is checked

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