Insert rows in table with checkbox
e:Nov 6 2009 — edited May 20 20101.select checkbox
2.press submit button
3.process run insert
Problem APEX_APPLICATION.G_F02(i) and APEX_APPLICATION.G_F03(i) no value!!
Query:
select APEX_ITEM.CHECKBOX(1,ID) " "
, APEX_ITEM.HIDDEN(2, USER_ID) || NAME_USU
, APEX_ITEM.HIDDEN(3, ROL_ID) || NAME_ROL
from USUROL_V
------------------------------------------------------------------------------------------------------------------------------
Process:
BEGIN
--
FOR i in 1..APEX_APPLICATION.G_F01.COUNT LOOP
--
INSERT INTO USUROL
( ID
, USER_ID
, ROL_ID )
VALUE
(v_id
,APEX_APPLICATION.G_F02(i)
,APEX_APPLICATION.G_F04(i)
);
--
END LOOP;
--
END;