Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help ...Oracle web server & PL/SQL

Help ...Oracle web server & PL/SQL

From: Divakar <kimmane_at_email.msn.com>
Date: Sat, 11 Apr 1998 22:03:42 -0400
Message-ID: <#DprzabZ9GA.208@uppubnews03>


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/&nbsp;<br>Coverage&nbsp;<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 select
   IS
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 - 21:03:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US