Re: Need direction on multiple cursor output from UTL_FILE

brenda.streed_at_empireblue.com wrote:
> I was hoping someone can answer a couple of questions about some Oracle
> packages, so that I can figure out which is the best approach to a
> problem.
>
> We need to output multiple files of CSV data that is derived from an
> Oracle table. IE. 5000+ separate files with its own data. I have been
> able to use UTL_FILE to create one file with CSV data, but the lines
> only represent the header information.
>
> My questions are:
> 1. Can UTL_FILE be used to output and individually save multiple files
> (so far everything I've seen in example code shows output to one file)?
>
> 2. Can a ref cursor be used in UTL_FILE? The data in my table has
> multiple detail lines for each parent record/person header. Each of
> the multiple saved files will have information for only one grouping of
> records.
>
> There may be a better approach to this task; please give me ideas. If
> anyone can point me in the right direction, I would appreciate it.
>
> Thanks,
> Brenda

Yes.

Demos in Morgan's Library under UTL_FILE at www.psoug.org.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)