Re: utl_file: to fflush or not to fflush?

From: Ronald <devnull_at_ronr.nl>
Date: 29 Oct 2001 01:08:36 -0800
Message-ID: <67ce88e7.0110290108.c71d295@posting.google.com>

Joost Mulders <mail_at_j-mulders.demon.nl> wrote in message news:<3BDC82E8.8A1409E4_at_j-mulders.demon.nl>...
> Hi,
>
> I am having a hard time with the code below (8.1.5, solaris). If the blob being put is > 32768, then the produced filesize is always 32768. The fflush in the loop is needed to write out the complete file. I think that's not what's documented.

Joost,

utl_file is not suitable for writing binary data. I think you need pro*c for this one. Unloading of data has never been a strong point with oracle. It's easy to get it in but once it is ....

Ronald.

http://ronr.nl/unix-dba Received on Mon Oct 29 2001 - 03:08:36 CST