Help, How to pass array in PL/sql

From: Divakar <kimmane_at_email.msn.com>
Date: 1998/04/11
Message-ID: <#ncyG2VZ9GA.200_at_uppubnews03>#1/1

Help .
[Quoted] Dos anyone know how to pass array as a parameter in pl?sql. The requirement goes like this.
I am using Oracle web server 3.0. Where I have html form which has  multile select box.what that means is that. List box shows n numbers of options and you can choose more than one orgument. When you submit this form recieving procedure shoul have a parament which is array to have this. sending procedure
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">');    IF NOT location_csr%ISOPEN
   THEN
      OPEN location_csr;
   END IF;
   LOOP FETCH location_csr into location_rec;    IF location_csr%FOUND THEN
   l_location_loop_count := l_location_loop_count + 1;    IF l_location_loop_count >= 1 then

     l_location_cd := location_rec.location_cd;
     l_location_tx := location_rec.location_tx;
     htp.p('<option value='||'"'||l_location_cd||'">'||l_location_tx);   END

IF;

   END LOOP;
   htp.formSelectClose;
   htp.p('</tr>');
REcining Procedure
 Procedure SP_VALIDATE

     LocationList IN varchar2 DEFAULT NULL, -- Multiple select
     Comments IN varchar2 DEFAULT NULL)  -- comments

   IS

Problem here is that even if you select more that one item in the list, on the recieving end how do you receive that data. In Because PL?SQL I guess you can pass only number, integer and Varchar2 as parameters. Plese help. Received on Sat Apr 11 1998 - 00:00:00 CEST