Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Procedure with parameters
"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 - 05:35:42 CST