Re: Web Forms and MULTIPLE SELECT support

From: <quirozj_at_ucs.ors.edu>
Date: Wed, 13 May 1998 09:54:17 -0700
Message-ID: <3559D038.2380@ucs.ors.edu>

Mathew,
You have to use the owa_util.ident_arr datatype and then use a loop to read and do something with the array.

something like this and this is only an example of how. You have to keep asking questions and finding answers.

package.procedure(sub_code in owa_util.ident_arr) is

begin

      subj_code := '';
      BEGIN
         WHILE (sel_subj(p) IS NOT NULL) LOOP
           subj_code := subj_code||lpad(sel_subj(p),5)||' ';
           p := p + 1;
         END LOOP;
      EXCEPTION 
         WHEN NO_DATA_FOUND THEN
              p := 2;
      END;

      do something else

end

Juan

Matthew Chalwell wrote:
>
> Hi,
> I hope someone can help me with the following query.
> I am writing web based forms using pl/sql, then processing the
> results of that form using another pl/sql procedure. The problem
> arises when I attemp to use "MULTIPLE SELECT" options in
> my form. I'm not sure how, or even if it is possible to read in more
> than one value for the same parameter.
>
> Any suggestions appreciated.
> Matt
Received on Wed May 13 1998 - 11:54:17 CDT