Re: Breaking integers into bytes in PL/SQL?

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 TELsoft