Re: WebDB - access to arguments?

From: Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be>
Date: 2000/05/30
Message-ID: <GDVY4.4750$dq.11795_at_afrodite.telenet-ops.be>#1/1


I do not have webdb at home so I can't check, but if my memories are good there must be
a procedure wwv_name_value.get_array (or something like that) that handles arays (in your case multiple selects)

Jim Lewis <pojpl_at_ais.ucla.edu> schreef in berichtnieuws 8h11kd$5kn$1_at_carroll.library.ucla.edu...
> Thank you Klaus! Your suggestion works perfectly for our reports that
> have just one parameter. We have added the PL/SQL code and they work
> great.
>
> We do have a couple of reports that can have multiple values for a
> given parameter (they are setup as "multiple select" parameters). Do
> you know what code we could write to test for such multiple-value
> parameters and then display the values?
>
> Thank you again.
>
> Jim.
>
> "Klaus Zeuch" <Klaus.Zeuch_at_erls04.siemens.de> wrote:
>
> >Hi,
 

> >to retrieve the value the user specified for parameter1 try this:
 

> >htp.p('Value of parameter1: ' ||
> >WEBDB.wwv_name_value.get_string(l_arg_names, l_arg_values, 'parameter1',
> >'YES'));
 
> >Please note: All values are returned as characters
 

> >Klaus
>
>
> >Jim Lewis <pojpl_at_ais.ucla.edu> schrieb in im Newsbeitrag:
> >8gploq$qki$1_at_carroll.library.ucla.edu...
> >> In the display of the results of a WebDB report we would like to have
> >> a heading line that includes the values the user specified for the
> >> parameters for the report.
> >>
> >> I suppose we would use the "Advanced PL/SQL" setup for this, but we
> >> don't know how to get access to the parm values the user specified so
> >> we can include them in such a report heading line.
> >>
> >> Anyone know how this can be done?
> >>
> >>
> >>
>
>
>
>
>
>
Received on Tue May 30 2000 - 00:00:00 CEST

Original text of this message