Why not just trim the new line of the data, and allow
put_line to do it.
hth
connor
- ryan_oracle_at_cox.net wrote: > Im reading from
user_source and writing the text of
> packages to files. Problem is that if i use
> UTL_FILE.PUT_LINE it adds an extra '/n'(end of line
> character or space) into the file. since the code
> itself is stored in the database with an end of line
> character.
>
> If I use UTL_FILE.PUT or UTL_FILE.PUTF and attempt
> to write it out after about 700 rows nothing else
> gets written to the file. So I assumed the buffer
> filled up, so every 200 rows I flushed the buffer.
>
> Same problem. I even tried opening and closing the
> file handler. Same problem.
>
> any ideas on how to get around this? I know I can
> just do a .sql and redirect it to a file in unix,
> but Id prefer to keep it in the database.
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: <ryan_oracle_at_cox.net
> INET: ryan_oracle_at_cox.net
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger
http://mail.messenger.yahoo.co.uk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Nov 14 2003 - 07:39:33 CST