Perplexing UTL_FILE.PUT_LINE Problem
- From: "Booth.Steve" <Steve.Booth@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Oct 2008 14:42:30 -0500
Running Oracle 10g (10.2.0.4.0) on UNIX.
I'm a Duhveloper and have recently experienced a problem that I just
can't figure out.
Background:
We have an application that exports Oracle data from a table to
a flat file (on UNIX). The application was originally written in Version
8. The basic methodology of this part of the application issues an SQL
Select statement which returns set of records of strings of 33
characters in length. The receiving variable is allocated as 100
characters.
This code has been working fine and hasn't been changed for
almost a year. The general logic is:
* Build SQL Select Statement
* Open Cursor with Select Statement
* Open UNIX File for writing
* Read first SQL Data record (FETCH Results_cur INTO
Output_buffer)
* While Results_cur%FOUND
* UTL_FILE.Put_line( File_handle, Output_buffer );
* ***
* FETCH Results_cur INTO Output_buffer;
* END Loop;
* Close UNIX File.
Since about noon on Monday we have been having intermittent
problems where the data being written is incorrect (just bad data
values, like a 0 instead of 274). In a vain attempt to figure out what
is (occasionally happening), I dumped the "Output_buffer" to a logging
table and it was not the same values as what was in the file. I did this
at the location of the "***".
In summary, it's intermittent and driving us nuts.
Thanks in advance for any suggestions.
Steve Booth
Other related posts:
