RE: PL/SQL output using UTL_FILE

From: Graeme Farmer <graeme.farmer_at_mincom.com>
Date: Wed, 7 Jul 2004 12:26:55 +1000
Message-ID: <DA5B390A2CBAA64AB2367C2EDA3210F60CA65729@tqxbneclu03.root.tequinox.com>

Warren,

Check out max_linesize in the fopen call:

  FUNCTION fopen(location     IN VARCHAR2,
                 filename     IN VARCHAR2,
                 open_mode    IN VARCHAR2,
                 max_linesize IN BINARY_INTEGER DEFAULT NULL)
           RETURN file_type;

Cheers,
Graeme.

-----Original Message-----

From: Warren Homer [mailto:wazhomer_at_hotmail.com] Sent: Wednesday, 7 July 2004 12:25 PM
To: oracle-l_at_freelists.org
Subject: PL/SQL output using UTL_FILE_DIR

Hi,

I am trying to run a PL/SQL procedure to unload a table to a file using utl_file_dir. As soon as the file's record length is greater than 1024 bytes (i.e 1 Kb) I receive an ORA-06512 error message. Is there some way to increase the output record length limit from 1K. Thanks.

Warren.

SEEK: Now with over 50,000 dream jobs! Click here: http://ninemsn.seek.com.au?hotmail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

--

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Jul 06 2004 - 21:24:05 CDT

RE: PL/SQL output using UTL_FILE_DIR