output to file (unix)

  Does anyone know of a way to output to multiple files from a pl/sql procedure. The filenames being made up from a field.

Example ::

	for tmp1 in cursor1 loop


     --   open output file using tmp1.field


            for tmp2 in cursor2 loop
              dbms_output.put_line(tmp2);
            end loop;


     --   close output file;


        end loop;


 

-- 
	 .-----------------------------.
	|        Todd M. Helfter	|
	|    tmh_at_staff.cc.purdue.edu	|
	 `-----------------------------'