Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help ...Oracle web server & PL/SQL
I am using Oracle web server 3.0.
I have a stored procedure which creates html form(
using HTP & HTF packages in PL/SQL) has a multi list box.
As required by the web server the names of the parameters
at both ends(seding &receiving ) are same .
Now If user select more then one LISTitem and submits the form.
How can I get the second value of the list selected.
Here is the sample code.
CREATE OR REPLACE
Procedure SP_emptyForm
IS
htp.p('<form action="PK_CONTACT.SP_VALIDATE" method="POST">')
htp.p('<tr>
<td align="right" valign="top">Operations/ <br>Coverage <br>
Location(s):</td><td align="left" colspan="3">
<select name="LocationList" MULTIPLE size="5">');
<option value="00">None </option>
<option value="AB">Alberta </option>
<option value="AK">Alaska </option>
<option value="AL">Alabama </option>
<option value="AR">Arkansas </option>
htp.p('</select></td></tr>'); htp.formSelectClose; htp.p('</tr>'); end ----------------------------------------------------------------- /* RECIEVING PROCEDURE to validate the form */ Procedure SP_VALIDATE( LocationList IN varchar2 DEFAULT NULL, -- Multiple selectIS
END; ---------------------------------------------------------------LocationList is varchar2. How do I get the second value selected in the LIST.