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

Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic FOR IN mySQL_String LOOP doSomething END LOOP, 8i

Re: Dynamic FOR IN mySQL_String LOOP doSomething END LOOP, 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Aug 2005 19:00:14 +0200
Message-ID: <l21kg1hm89048jngt4jmu7k089k17hnkeo@4ax.com> 





On Mon, 22 Aug 2005 17:24:42 +0200, COAST <coast_at_cedes.com> wrote:



>So I want to concatenate mySQL_String dynamically and use allways the same

>FOR IN command.




Just drop the for in loop


and replace by NDS: a ref cursor and individual fetches.
You will end up with one loop, with a few more lines of code.


--
Sybrand Bakker, Senior Oracle DBA


Received on Mon Aug 22 2005 - 12:00:14 CDT












Original text of this message













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