title: get every result of a query to use after
body: <p>I'm trying to get every result of a query to then print an output and make other query with the result. I'm trying to make it with a Cursor. But when I try to print the query result it says me:</p>
  
  <pre><code>PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
  </code></pre>
  
  <p>My code is:</p>
  
  <pre><code>DECLARE
  -- Store the SELECT query in a cursor
    CURSOR l_cur IS select memname from emuser.DEF_TABLES@controlm t, emuser.DEF_JOB@controlm j where (t.TABLE_ID = j.TABLE_ID) and t.sched_table = 'DWHRAC_DIARIOS2_DC2'; 
  --Create a variable that will hold each result from the cursor
    l_cur_rec l_cur%ROWTYPE;
  BEGIN
    -- Open the Cursor so that we may retrieve results
    OPEN l_cur;  
    LOOP
      -- Get a result from the SELECT query and store it in the variable
      FETCH l_cur INTO l_cur_rec;
      -- EXIT the loop if there are no more results
      EXIT WHEN l_cur%NOTFOUND;
      -- INSERT INTO another table that has the same structure as your results
                DBMS_OUTPUT.PUT_LINE( l_cur_rec);
  
    END LOOP;
    -- Close the cursor to release the memory
    CLOSE l_cur;
  END;
  </code></pre>
  
  <p>Could you help me please?
  Thanks</p>