Re: UTL_FILE > 1023 bytes with Oracle 7.3.4

From: Christopher Spence <nospam_at_vampired@mediaone.net>
Date: Fri, 25 Feb 2000 03:34:54 GMT
Message-ID: <kltbbs0uorvppqbdp426t3c01p3lbnkjbh@4ax.com>

PL/SQL UTL_FILE package. But under 7.3.4 the max line size is 1022. anything more causes exception.

there doesn't seem to be anyway around it without using outside scripting. But we don't want to use SQL Loader as we want it handled via the database.

On Thu, 24 Feb 2000 05:01:55 -0800, rockcogar <rock_cogarNOroSPAM_at_my-deja.com.invalid> wrote:

>Christopher,
>
>What exactly is it that is giving you trouble ?
>
>There are many ways to load data into Oracle. I use:
>
>1. Import.
>2. SQL Loader.
>3. Access 97 (export to ODBC database).
>4. Import Utility in Golden (http://www.benthicsoftware.com/)
>5. PL/SQL using UTL_FILE.
>6. Visual C++ and ODBC.
>7. Scripts.
>
>Rock.
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

Christopher Spence
Senior MIS Engineer
A+ CNA Raptor Received on Thu Feb 24 2000 - 21:34:54 CST