Re: HELP! I am stuck with the 1023 width limit of UTL

From: Michael Krolewski <vandra_at_u.washington.edu>
Date: Tue, 20 Apr 1999 01:16:24 -0700
Message-ID: <371C37D7.EC72430C@u.washington.edu>

The boring method is to use SQLplus spooling the data to the file. If you turn off

        feedback
        verify
        heading
        echo

        set pagesize to 0

        I believe the file will only contain the data. (There could be

other elements to set off )

Mike Krolewski

Guayo wrote:

> I need to export files from the database (Oracle v 7.3.3)
> to a plane file but TEXT_IO is very slow
> and the files are wider of 1023
> does any alternative exist?
>
> Thanks
> Eduardo Santisbón
Received on Tue Apr 20 1999 - 03:16:24 CDT

Re: HELP! I am stuck with the 1023 width limit of UTL_FILE