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

Home -> Community -> Usenet -> c.d.o.misc -> How to spool in a cursor loop

How to spool in a cursor loop

From: egkua <egkua_at_tm.net.my>
Date: 10 Jan 2004 21:10:41 -0800
Message-ID: <b2803687.0401102110.71321adb@posting.google.com>


I would like to create a file using a spool while in a cursor loop. Loop
  if false
    spool off
    true;
    file1 = '..';
  end if
  if true
    spool file1
  end if
  DBMS_OUTPUT.PUT_LINE(...);
End Loop

It this possible and how? Received on Sat Jan 10 2004 - 23:10:41 CST

Original text of this message

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