Re: Multiple Selects

You need to create your receiving procedure with a PL/SQL table as the input parameter to receive the multiple selections:

    Procedure Test( programmer in asp_owa_util.big_arr)

        For Loopcnt in programmer.first..programmer.last
        Loop

            If  programmer.exists(loopcnt) Then

                    --do something with programmer(loopcnt);

            End If; -- exists

        End Loop;

    End;

John Thwaites
AlliedSignal Inc.
Polymers Division

Shellie Schantz-Hubert wrote:

> Thank you for your quick response, but that isn't exactly what I need.
>
> I'm trying to go from a Web page to a PL/SQL procedure, I want to be
> able to pass more than one value from the HTML FORM (MULTIPLE SELECT)
> to the procedure, assigned to the same variable.
>
> Shellie
>
> Shellie Schantz-Hubert wrote:
> >
> > Is there a way for PL/SQL to parse Multiple select statements. OR does
> > Oracle PL/SQL Just not allow it?
> >
> > <SELECT NAME="programmer" MULTIPLE>
> > <OPTION VALUE="programmer1">Programmer 1</OPTION>
> > <OPTION VALUE="programmer2">Programmer 2</OPTION>
> > <OPTION VALUE="programmer3">Programmer 3</OPTION>
> > <OPTION VALUE="programmer4">Programmer 4</OPTION>
> > <OPTION VALUE="programmer5">Programmer 5</OPTION>
> > <OPTION VALUE="programmer6">Programmer 6</OPTION>
> > </SELECT>
> >
> > Shellie Hubert
> > The Iserv Company
Received on Fri Feb 26 1999 - 12:04:07 CST