Cursor output to CSV

From: Helge <hmoulding_at_gmail.com>
Date: 9 Jun 2006 13:46:51 -0700
Message-ID: <1149886011.331439.20880@j55g2000cwa.googlegroups.com>

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. Received on Fri Jun 09 2006 - 15:46:51 CDT