PL/SQL output using UTL_FILE_DIR 2004-07-06 - By Graeme Farmer
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@(protected)]
Sent: Wednesday, 7 July 2004 12:25 PM
To: oracle-l@(protected)
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 (See ORA-06512.ora-code.com) 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
