When reading in stream mode, does Oracle8i use synchronous or asynchronous reads? That is, does control return to the client after the first chunk read or only at the end of a chunk read?
You can read BLOBs in two modes: • Piecewise fetch mode. • See Oracle8 Application Developer’s Guide – Large Objects (LOBs) for more information. • Polling or streaming mode • For polling or streaming reads, you can specify an offset and an amount. Streaming does not mean you read the complete BLOB at once, and there is no “chunk” mode. Whether or not Oracle8i uses synchronous or asynchronous reads depends on whether the user specifies CACHE or NOCACHE during the creation of the LOB column. If the user specifies NOCACHE, then reads and writes are performed asynchronously, or “directly” and the LOB blocks do not go through the buffer cache.
