Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Advice on Dumping a Cursor to a Text file..

Advice on Dumping a Cursor to a Text file..

From: <tim.mcconechy_at_runtime.dk>
Date: 2000/03/31
Message-ID: <8c2c3p$nkc$1@nnrp1.deja.com>#1/1

HI!

I want to make a generic Procedure in PL\SQL using UTL_FILE

That will accept a cursor and
Create a ; delimited text file based on it's contents.

Has anyone out there had experience with this.

The trick is to convert all file types to char and the fact that I don't know how many columns or what the column types would be..

Can anyone give me any advice on how to approch this ...

Thanks!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 31 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US