Re: Help: Oracle WebServer vs Multiselect listboxes

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1997/02/14
Message-ID: <3303d453.5951027_at_nntp.mediasoft.net>#1/1

you will pass them in as a pl/sql table type.

code your routine as:

create or replace procedure myProc( multiple in owa.vc_arr ) is
begin

	for i in 1 .. 10000
	begin
		htp.p( multiple(i) );
		htp.br;
	exception
		when no_data_found then exit;
	end;
	end loop;

end;

See http://govt.us.oracle.com/ under downloadable utilities for a set of packages (owa extensions) that automate generating lists from queries and other things....

On 13 Feb 1997 20:06:09 GMT, "Damien Jones" <damien_at_seanet.com> wrote:

>[I'm not even sure this is the right newsgroup to be posting in. Is there
>one specifically for Oracle Web Server questions? Iif so, my work doesn't
>subscribe to it]
>
>Here's my problem:
>
>I'm doing a relatively simple Oracle WebServer page with a multi-select
>listbox. On Submit, my procedure has to interpret the input the listbox
>provides. In other cases, I can simply set up my routine with as many
>variables (named the same) as fields on my page. Unfortunately, an HTML
><SELECT MULTIPLE Name="vMultiple"> statement returns values like this:
>
>ProcedureName?vMultiple=Selection1&vMultiple=Selection2&vMultiple=Selection3
>
>
>The good news is that I don't just get a blanket "Request Failed" page when
>submitting multiple entries - it simply ignores all selections after the
>first...
>
>The bad news (obviously) is that I do need it to capture all of the chosen
>items. If I could somehow get them all into one delimited variable, I could
>easily loop and parse out the entries within my procedure.
>
>Any ideas?

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Fri Feb 14 1997 - 00:00:00 CET