Re: Multiple Selects

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 25 Feb 1999 01:02:46 GMT
Message-ID: <36d5a059.11904698@192.86.155.100>

A copy of this was sent to Shellie Schantz-Hubert <shellie_at_portup.com> (if that email address didn't require changing) On Wed, 24 Feb 1999 20:20:20 GMT, you wrote:

>Is there a way for PL/SQL to parse Multiple select statements. OR does
>Oracle PL/SQL Just not allow it?
>

<form action=my_pkg.my_procedure method=post>

><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>

<input type=submit>
</form>

and a procedure like:

create or replace package my_pkg
as

	type myArray is table of varchar2(30) index by binary_integer;
	emptyArray myArray;

	procedure my_procedure( programmer in myArray default emptyArray );

end;
/

create or replace package body my_pkg
as

procedure my_procedure( programmer in myArray default emptyArray ) is
begin

	for i in 1..programmer.count loop
		htp.p( programmer(i) || '<br>' );	
	end loop;

end;

end;
/

will do it...

>Shellie Hubert
>The Iserv Company
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Feb 24 1999 - 19:02:46 CST