Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE - how to write > 1KB to OS file without line terminator ?

Re: UTL_FILE - how to write > 1KB to OS file without line terminator ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 30 Nov 1999 08:43:01 -0500
Message-ID: <k1l74ssai6os0p6utvf0bmm5p9ck32fp15@4ax.com>


A copy of this was sent to "Igor Oussoltsev" <uwd_at_uwd.baltnet.ru> (if that email address didn't require changing) On Tue, 30 Nov 1999 00:24:25 +0200, you wrote:

>Hi All's!
>My problem is following:
>I try to put set of characters from DB table (Oracle 8.0.5/Windows NT
>4.0+SP3)
>to OS file.

In 8.0.5 and up, the spec of fopen is now:

FUNCTION FOPEN RETURNS RECORD

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
   ID                           BINARY_INTEGER          OUT
 LOCATION                       VARCHAR2                IN
 FILENAME                       VARCHAR2                IN
 OPEN_MODE                      VARCHAR2                IN
 MAX_LINESIZE                   BINARY_INTEGER          IN


set max_linesize to some number upto 32k to make the linesize be that (instead of ~1000 bytes)

>My procedure like:
>
>CREATE OR REPLACE PROCEDURE MY_PROC IS
>
>c_ount NUMBER :=0;

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 30 1999 - 07:43:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US