Re: WebDB 2.2 Reports

Heeyyy!! That's great!! It does work!!
Thanks a lot!

Montse Collados Polidura
CERN - Switzerland

Zdenek Zavadil wrote:
>
> In article <38DF129D.245CD0F5_at_cern.ch>,
> Montse COLLADOS POLIDURA <Montse.Collados_at_cern.ch> wrote:
> > Hi,
> >
> > I would like to get the number of rows returned when displaying the
> report results.
> > Something like :
> > -------
> > Report results title.
> >
> > Number of rows returned: <number>
> >
> > table with results...
> > --------
> >
> > I tried to do it usign PL/SQL but it does not recognize the bind
> variables. They are the same ones that I use to create the report.
> >
> > select count(*) into num
> > from user1.table1
> > where name = :name_v and
> > surname = :surname_v ;
> > htp.print('<H2>Number of rows returned: </H2>'|| num);
> >
> > What am I doing wrong?
> > Is there any other way of doing so?
> >
> > thanks for your time and help,
> > Montse Collados Polidura
> > CERN - Switzerland
> >
>
> Hi Montse.
> Try this:
>
> declare
> num number;
> par1 varchar2(64);
> par2 varchar2(64);
> begin
> par1 := WEBDB.wwv_name_value.get_string(l_arg_names, l_arg_values,
> 'name_v');
> par2 := WEBDB.wwv_name_value.get_string(l_arg_names, l_arg_values,
> 'surname_v');
> select count(*) into num
> from user1.table1
> where name = par1 and
> surname = par2;
> htp.print('<H2>Number of rows returned: </H2>'|| num);
> end;
>
> HTH,
> Zdenek
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Mar 28 2000 - 18:34:29 CEST