My Oracle Support Banner

SQL/LOB: Piecewise Writes and Reads of LOBs (Doc ID 50910.1)

Last updated on JULY 02, 2022

Applies to:

Oracle Database - Personal Edition - Version 8.0.3.0 to 11.2.0.1 [Release 8.0.3 to 11.2]
Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.1 [Release 8.0.3 to 11.2]
Oracle Database - Standard Edition - Version 8.0.3.0 to 11.2.0.1 [Release 8.0.3 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Generic (Platform Independent)

Goal


This OCI program inserts a row into a BLOB using piecewise operations, currently with buffering enabled.
It also gives instructions for piecewise operations without buffering. Once the row has been inserted it is read back in pieces. In both the read and write no callback functions are used - the read and write functions are simply repeatedly called while OCI_NEED_DATA is returned.

The application needs the following table to be created:


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.