Dynamic Query

From: Cedric ROCHE <cedric.roche_at_snv.jussieu.fr>
Date: Wed, 02 Sep 1998 14:16:05 +0200
Message-ID: <35ED3705.8B11ED2D_at_snv.jussieu.fr>

Hello,

[Quoted] We used Developer 2000 Builder 2.0 and in a form we wanted to build a special PL/SQL procedure.

This procedure receive in parameters a name of a table (toto) and we wanted to make a query like :

select count(*) from toto ;

Is it possible ?

The procedure could be like this :

---

procedure Trait( toto char, resu integer) is begin
select count(*) into resu from toto ;
end ;

---

Thank you for your help .

Cedric Received on Wed Sep 02 1998 - 14:16:05 CEST