Referencing Values Within an On Submit Process

You can reference the values posted by an HTML form using the PL/SQL variable HTMLDB_APPLICATION.G_F01 to HTMLDB_APPLICATION.G_F50. Because this element is an array, you can reference values directly, for example:

FOR i IN 1.. HTMLDB_APPLICATION.G_F01.COUNT LOOP 
    htp.p('element '||I||' has a value of '||HTMLDB_APPLICATION.G_F01(i)); 
END LOOP;

Note that check boxes displayed using HTMLDB_ITEM.CHECKBOX will only contain values in the HTMLDB_APPLICATION arrays for those rows which are checked. Unlike other items (TEXT, TEXTAREA, DATE_POPUP) which can contain an entry in the corresponding HTMLDB_APPLICATION array for every row submitted, a check box will only have an entry in the HTMLDB_APPLICATION array if it is selected.