Hello there.
I'm trying to create a dynamic form with the following PLSQL....When I click the submit button I get NO values from these form elelments. It appears that the entire page is "wrapped" in a form tag. The checkboxes and text input field draw fine but they are never SUBMITTED....
form action="wwv_flow.accept" method="post" name="wwv_flow" id="wwvFlowForm" novalidate="" autocomplete="off" _lpchecked="1"
------PLSQL CODE
DECLARE
v_group_name VARCHAR2(100);
v_id NUMBER;
v_description VARCHAR2(100);
v_label VARCHAR2(500);
CURSOR get_groups IS
SELECT DISTINCT group_name
FROM queries;
/* Second cursor */
CURSOR get_details IS
SELECT id,description,label from queries where group_name = v_group_name
order by id ;
BEGIN
open get_groups;
LOOP
fetch get_groups into v_group_name;
exit when get_groups%notfound;
htp.p('<DIV>'||v_group_name||'</DIV>');
open get_details;
LOOP
fetch get_details into v_id,v_description,v_label;
exit when get_details%notfound;
htp.p(APEX_ITEM.CHECKBOX(v_id,v_id,'CHECKED'));
htp.p(v\_id);
htp.p(v\_description);
htp.p(v\_label);
END LOOP;
close get_details;
END LOOP;
close get_groups;
htp.p(APEX_ITEM.TEXT(10,'test'));
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
END;