Hello,
I'm discovering APEX and I have a problem.
I've declared a page :
select art_id, PIL_NB_POA, apex_item.hidden(99,poc_id) || APEX_ITEM.CHECKBOX(2,PIL_CO_CRITIQUE_CLIENT,DECODE(PIL_CO_CRITIQUE_CLIENT,1,'CHECKED',NULL)) PIL_CO_CRITIQUE_CLIENT, APEX_ITEM.TEXTAREA(3,PIL_LB_COMMENTAIRES,2,70) PIL_LB_COMMENTAIRES from from TEPOA_PILOTAGE@dkey
I see my data, but when I want to update the table with the checkbox and the text area, i have an error ORA-01403
I have a process :
BEGIN
FOR i in 1..APEX_APPLICATION.G_F41.COUNT
LOOP
UPDATE TEPOA_PILOTAGE@dkey set PIL_CO_CRITIQUE_CLIENT = APEX_APPLICATION.G_F02(i) where POC_ID = APEX_APPLICATION.G_F99(i);
UPDATE TEPOA_PILOTAGE@dkey set PIL_LB_COMMENTAIRES = APEX_APPLICATION.G_F03 where POC_ID = APEX_APPLICATION.G_F99(i);
END LOOP;
COMMIT;
END;
If i only keep the text area it works, maybe I don't use the checkbox properly.