benedetto_at_XXXXBluXP.com said...
> 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
> >
> >
>
You might go to http://asktom.oracle.com/ and search for "resultset"
(without quotes). You'll get more examples than you can shake a stick
at.
--
/Karsten
DBA > retired > DBA
Received on Tue Feb 18 2003 - 14:51:42 CST
