Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Form Fields from HTP.P are not submitting with the rest of the APEX Items on the page...

bostonmacosxDec 3 2021

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;

This post has been answered by Joe Upshaw on Dec 3 2021
Jump to Answer
Comments
Post Details
Added on Dec 3 2021
2 comments
164 views