node-oracledb

5. Lob Class

Lob objects can be used to access Oracle Database CLOB and BLOB data.

A Lob object implements the
Node Stream interface.

See Working with CLOB and BLOB Data for more information.

5.1 Lob Properties

The properties of a Lob object are listed below.

5.1.1 chunkSize

readonly Number chunkSize

This corresponds to the size used by the Oracle LOB layer when
accessing or modifying the LOB value.

5.1.2 length

readonly Number length

Length of a queried LOB in bytes (for BLOBs) or characters (for CLOBs).

5.1.3 pieceSize

Number pieceSize

The number of bytes (for BLOBs) or characters (for CLOBs) to read for
each Stream 'data' event of a queried LOB.

The default value is chunkSize.

For efficiency, it is recommended that pieceSize be a multiple of
chunkSize.

The maximum value for pieceSize is limited to the value of UINT_MAX.

5.1.4 type

readonly Number type

This read-only attribute shows the type of Lob being used. It will
have the value of one of the constants
Oracledb.BLOB or
Oracledb.CLOB. The value is derived from the
bind type when using LOB bind variables, or from the column type when
a LOB is returned by a query.