Re: PL/SQL and Oracle Webserver

if you are having OWS 2.1 then the solution to the above problem is given in the Online docs section in the Oracle Web Server Administration page.basically the idea is to use a type declaration (type ident_arr is table of varchar2(30) index by binary_integer)and pass this one variable to the next procedure.then you can loop through until no-data-found to extract all the checked values.unchecked values are not sent. have tried it.it works! hope this helps

shivshan

In article <34D74D7A.5B75C879_at_non-hp-usa-om46.om.hp.com>,   michael_rothwell_at_non-hp-usa-om46.om.hp.com wrote:
>
> I have used a PL/SQL table for this purpose in the past. I
> then read through table to get a list of what check boxes
> were checked. I do this because I am writing check boxes
> based on information from the DB - I never now how many
> possible choices there may be and the PL/SQL table handles
> it.
>
> Michael.
>
> John Thwaites wrote:
> >
> > In the case of the multiple selection list box the data is returned as a
> > PL/SQL table into a single parameter. Any other field type can be passed
> > into a procedure in the same way by giving each occurrance of the object the
> > same name eg. a set of check boxes.
> >
> > John Thwaites
> > AlliedSignal - Polymers
> >
> > nilayo_at_magnet.com.tr wrote:
> >
> > > I have the problem of not knowing exactly the number of parameters which
> > > will be passed to the pl/sql procedure, so I can not specify the
> > > procedure header which is going to process the request. Take for example
> > > the case where you use a multiple selection list box, where you don't
> > > know how many of them are going to be selected, so you can not write a
> > > procedure to process the request. Is there a solution other then writing
> > > a procedure for all of the cases?
> > >
> > > -------------------==== Posted via Deja News ====-----------------------
> > > http://www.dejanews.com/ Search, Read, Post to Usenet

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet