Re: Need direction on multiple cursor output from UTL_FILE

"brenda.streed_at_empireblue.com" <brenda.streed_at_empireblue.com> wrote in news:1126707890.495876.91420_at_g14g2000cwa.googlegroups.com:

> 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
>
>

I suggest you visit
http://asktom.oracle.com
and do a keyword search on UTL_FILE.
Tom has many, many fine coding examples. Received on Wed Sep 14 2005 - 16:58:35 CEST