Re: Procedure with parameters

thx you're very kindly, thanks for your help !!!

Fortunatly in this usenet there are a lot of people.

Please next time, if you don't want answer to a question, save your/our time and skip to another.

bye
Mauro

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ha scritto nel messaggio news:v54v39smg0mr8e_at_corp.supernews.com...
> Why do that, if there are PL/SQL manuals with examples and numerous FAQ
> resources?
>
> Regards
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
> "Mauro" <benedetto_at_XXXXBluXP.com> wrote in message
> news:Uhs4a.19187$uA5.472937_at_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 Thu Feb 20 2003 - 09:21:14 CST