Re: Procedure with parameters

From: Mauro <benedetto_at_XXXXBluXP.com>
Date: Tue, 18 Feb 2003 16:27:48 +0100
Message-ID: <Uhs4a.19187$uA5.472937@tornado.fastwebnet.it>

thx for the answer, can you answer with an example, please?

thx
Daniele

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> ha scritto nel messaggio news:1045567905.826924_at_news.thyssen.com...
> "Mauro" <benedetto_at_XXXXBluXP.com> schrieb im Newsbeitrag
news:OLm4a.18236$uA5.459426_at_tornado.fastwebnet.it...
> > How can I write a procedure where I pass a string parameter containing a
SQL
> > command (like select * from TB_TEST) and
> > receive a recorset.
> >
> > thx
> > Daniele
> >
> >
>
> Hi Daniele,
>
> just pass it in a varchar2 param and then use dynamic sql
> to execute it.
>
> hth,
> Guido
>
>
Received on Tue Feb 18 2003 - 09:27:48 CST