Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Procedure with parameters
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...Received on Tue Feb 18 2003 - 12:19:44 CST
> 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
> >
> >
>
>