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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to "append" using utl_file package?

Re: how to "append" using utl_file package?

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 18 Nov 1998 22:07:26 GMT
Message-ID: <36534084.3154080@news.siol.net>


On Wed, 18 Nov 1998 19:39:45 GMT, badstreetboy_at_my-dejanews.com wrote:

>I am trying to use the utl_file package to dump out the data into a file. As
>far as I know, what utl_file.put_line does is write out the whole line. What
>if I want to append the data to the end of the last line? What can I do?

Use UTL_FILE's procedures PUT or PUTF, which add the buffer contents to the end of opened file, without adding the line termiantor. If you want to put a line terminator explicitely, use the procedure UTL_FILE.NEW_LINE.
>Thanks.
>
>BSB
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Nov 18 1998 - 16:07:26 CST

Original text of this message

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