Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to spool in a cursor loop
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
![]() |
![]() |