Re: WebDB 2.2 Reports

[Quoted] 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 - 09:14:12 CEST