title: Oracle PL/SQL EXECUTE IMMEDIATE in FOR loop
body: <p>I want to do something like the following.</p>
  
  <p>I need a loop for all the IDs from dynamic table,</p>
  
  <pre><code>FOR ID_ROW IN (EXECUTE IMMEDIATE 'SELECT ID FROM ' || SRC_TABLE) LOOP
      -- some SP calling with ID_ROW.ID
  END LOOP;
  </code></pre>
  
  <p>It is not working, how can I make it run?</p>
  
  <p>Or if following works then also I can work out a solution,</p>
  
  <pre><code>EXECUTE IMMEDIATE 'SELECT ID FROM ' || SRC_TABLE INTO ID_ROW
  </code></pre>
  
  <p>Where ID_ROW would be of type <code>type CUSTOM_ARRAY is table of VARCHAR2(64);</code></p>