Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Problems with dynamic SQL in Oracle.

Re: Problems with dynamic SQL in Oracle.

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: Thu, 29 Mar 2001 11:31:39 +0200
Message-ID: <99uvep$kjk$1@news.inet.tele.dk>

>
> However, as I explore each of these techniques, it doesn't seem clear to
 me
> that any of these methods return a "normal" result set. Is there any way
 to
> write PL/SQL code to treat a dynamic query which yields a multi-row result

Look at this link. Best explanantion on the net for refcursors :-)

http://govt.oracle.com/~tkyte/ResultSets/index.html

Peter Laursen Received on Thu Mar 29 2001 - 03:31:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US