Re: Accessing variables in select...

From: Michael Rothwell <michael_rothwell_at_non-hp-usa-om46.om.hp.com>
Date: 1998/02/03
Message-ID: <34D74E5A.C4F164CA@non-hp-usa-om46.om.hp.com>#1/1

This procedure should be declared as 'procedure( var1 in 'pl/sql table')
where 'pl/sql table' is a table of varchar2(nn) that has been previously declared. You may then loop through the table to view each value that has been assigned to var1.

Michael.

Armando Aguirre Schlick wrote:
>
> I'm working in a Oracle WebServer and in a page I have a select
> object with MULTIPLE option... How can I catch the values of the variable??
> I try to look for something in the URL, but it looks like that:
> http://my_server/my_DCD/owa/procedure?var1=value1&var1=value2&var1=vlue5
>
> I print the value of var1 but just print "value1".
> I declared the procedure "procedure" as 'procedure ( var1 IN VARCHAR2)'.
> Is it the problem the type of the var1??
>
> Thanx, and please excuse me for my bad english.
> --
> Armando Aguirre Schlick mailto:lxa_at_inf.utfsm.cl
> Estudiante De Ingenieria Civil en Informatica
> Universidad Tecnica Federico Santa Maria
> http://www.inf.utfsm.cl/~lxa
Received on Tue Feb 03 1998 - 00:00:00 CST