Re: Breaking integers into bytes in PL/SQL?
Date: Mon, 29 Nov 1999 14:16:40 +0100
Message-ID: <38427CB8.5FC692A7_at_protek.no>
Yepp!
But as someone else has pointed out, the UTL_FILE.FFLUSH doesn't work
in Oracle 7.x and Oracle supposedly won't fix it.
This was some banking application developer for a large bank somewhere..
he just got the message "upgrade".
Paul Cluiss wrote:
>
> If you want good throughput, you don't want to close and re-open your
> file handles w/every write.
>
> Paul Cluiss
> Dallas, Texas
>
> Jan-Helge Bergesen wrote:
>
> > .. and speaking of SNP jobs .. are there any way of flushing
> > the buffers used by the UTL_FILE package explicitly?
> > UTL_FILE.FFLUSH does not work when run in such a job.
> > How ever if the filehandle is closed after each write -- all is well
> > (except from the fact that the listener recieves the error signal
> > (SIGPIPE ?), which can be quite annoying and consume some time).
> >
> > Suggestions?
> > --
> > Jan-Helge Bergesen
-- Jan-Helge Bergesen +4755225759 Protek TELsoftReceived on Mon Nov 29 1999 - 14:16:40 CET