Re: Cursor output to CSV

Helge wrote:
> This has been asked before, but the answer just pointed at Ask Tom.
> There are solutions similar to my question there, but nothing that
> quite fits.
>
> The problem is: How do you output a cursor to csv? It's easy if you
> know the structure of the cursor ahead of time, but that presents
> maintenance problems. What's needed is a generic method.
>
> Tom describes using dbms_sql, but as far as I can tell there's no way
> of associating a dbms_sql cursor handle (an integer that's normally set
> up by calling dbms_sql.open_cursor) with an open ref cursor. If there
> is a way, I'd love for someone to point it out to me.

Don't know anything about it but Crystal Delivery sounds like what you want: http://www.dirfile.com/freeware/csv.htm

jg

--
@home.com is bogus.
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9001087&pageNumber=1