Path: news.easynews.com!easynews!sjcppf01.usenetserver.com!usenetserver.com!sn-xit-04!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: zibi_at@hotmail.com (Zbigniew)
Newsgroups: comp.databases.oracle.misc
Subject: I can not write CHR(0) to a file using UTL_FILE package
Date: 10 Oct 2001 01:43:23 -0700
Organization: http://groups.google.com/
Lines: 15
Message-ID: <8d362333.0110100043.293ca68@posting.google.com>
NNTP-Posting-Host: 195.94.217.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1002703403 899 127.0.0.1 (10 Oct 2001 08:43:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2001 08:43:23 GMT
Xref: easynews comp.databases.oracle.misc:70110
X-Received-Date: Wed, 10 Oct 2001 04:34:04 MST (news.easynews.com)

Hi All,

I write some information from database tables to files. I do it
periodically using Oracle JOBS and UTL_FILE package. It works OK but I
have problem with one value. I can not write CHR(0) to a file. Oracle
treats it as a string terminator.
Is there any way or workaround to do it?
I am using Oracle8i Enterprise Edition Release 8.1.7.
Thanks in advance for your help.

Regards,
Zbyszek Sliwa
Oracle Programmer-Analyst
Nationwide
sliwaz@nationwide.com