PL/SQL output using UTL_FILE_DIR

From: Warren Homer <wazhomer_at_hotmail.com>
Date: Wed, 07 Jul 2004 12:25:22 +1000
Message-ID: <BAY22-F219MvuHdPtnh0000c712@hotmail.com>

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

---

Received on Tue Jul 06 2004 - 21:20:08 CDT