Yes, make your own UTL_FILE-Package
where you first cut the text into pieces and
then PUT it to the file:
...
- -------------------------------------
PROCEDURE put
- -------------------------------------
( p_filehandle IN File_Type
, p_text IN VARCHAR2
)
IS
v_text VARCHAR2(1023); -- because of BUG
v_len NUMBER;
i INTEGER;
BEGIN
--
i := 1;
v_text := SUBSTR ( p_text, 1, 1023);
v_len := LENGTH ( v_text);
--
UTL_FILE.PUT( p_filehandle, v_text);
--
WHILE v_len < LENGTH( p_text)
LOOP
v_text := SUBSTR( p_text, v_len + 1, 1023);
v_len := LENGTH(v_text) + i*1023;
i := i + 1;
--
UTL_FILE.PUT( p_filehandle, v_text);
--
END LOOP;
--
UTL_FILE.FFLUSH( p_filehandle );
--
EXCEPTION
WHEN UTL_FILE.INVALID_FILEHANDLE
THEN
RAISE_APPLICATION_ERROR
( -20104
, 'MY_FILE.Put: Invalid File Handle'||CHR(10)||SQLErrM
);
WHEN UTL_FILE.INVALID_OPERATION
THEN
RAISE_APPLICATION_ERROR
( -20105
, 'MY_FILE.Put: Invalid Operation'||CHR(10)||SQLErrM
);
WHEN UTL_FILE.WRITE_ERROR
THEN
RAISE_APPLICATION_ERROR
( -20106
, 'MY_FILE.Put: Write Error'||CHR(10)||SQLErrM
);
END put;
- -------------------------------------
PROCEDURE put_line
- -------------------------------------
( p_filehandle IN File_Type
, p_text IN VARCHAR2
)
IS
BEGIN
--
put( p_filehandle, p_text );
--
new_line( p_filehandle );
--
END put_line;
- -------------------------------------
...
Hooperce schrieb:
>
> Is there any way to have an output line from UTL_FILE go over 1k in length?
> Thanks in advance...
> Chuck Hooper
> Pro Relational Systems
> Charles_Hooper_at_ProRelSys.Com
The original text-variable can have up to 32kByte I think.
In my case it works fine.
Hope this helps
Reinhard
E-Mail_at_work: mailto:wahl_at_zv.fhg.de
E-Mail_at_home: mailto:ReinhardWahl_at_online.de
----------------------------------------------------
Website
http://www.online.de/homepages/ReinhardWahl
Hiermit widerspreche ich der Nutzung oder
Uebermittlung meiner Daten fuer Werbezwecke
oder fuer die Markt- oder Meinungsforschung
gemaess Par. 28 Abs. 3 Bundesdatenschutzgesetz.
Please do not use my E-Mail address for advertising!
Received on Wed Dec 23 1998 - 06:24:41 CST