Oracle web server 3.0 And PL/SQL Help needed
Date: 1998/04/11
Message-ID: <eejZ5ZbZ9GA.210_at_uppubnews03>#1/1
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>
[Quoted] <td align="right" valign="top">Operations/ <br>Coverage <br>
[Quoted] 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
BEGIN
htp.p('<BR>LocationList --:'||LocationList);
END; ---------------------------------------------------------------
LocationList is varchar2. How do I get the second value selected in the
LIST.
BAd part of this web server is that Oarcle dos not give access
to ENV variable QUERY_STRING.
Please help me.
Thanks,
Divakar.
Received on Sat Apr 11 1998 - 00:00:00 CEST