Re: PL/SQL Loop and Spool Question

Hi

DBMS_OUTPUT.PUT_LINE will help on your case

also set sqlplus environment as set serveroutput on size 20000

HTH
Pradhan

Rob Vicker wrote in message <7t37g3$bp3_at_ng1.icn.state.ia.us>...
>I know that technically SQL*Plus doesn't support loops but, PL/SQL does. I
>am trying to read in customer values from the customer table and execute a
>SQL statement for each customer with using the customer name as a parameter
>to the query. This all seems to work fine but, I am also spooling this
data
>to a file and I want to use the customer name as the name of the file (it
is
>there billing detail). Does anyone know how to use a loop and set a new
>filename on the spool function each time you go through the loop?
>
>Thanks in advance.
>
>-Rob
>
>
Received on Sat Oct 02 1999 - 16:02:16 CEST