Class IOracleClob

This method closes a previously opened CLOB.

This method compares two entire CLOBs or parts of two CLOBs.

Returns

0 if the compared portions are equal, non-zero if not

Throws

Error if offset1 or offset2 is not a valid CLOB offset value.

createTemporary creates a temporary CLOB and its corresponding index in your default temporary tablespace. The temporary CLOB is created with SESSION duration.

This method frees the temporary CLOB in the default temporary tablespace.

When creating the table, you can specify the chunking factor, a multiple of tablespace blocks in characters. This corresponds to the chunk size used by the CLOB data layer when accessing or modifying the CLOB value. Part of the chunk is used to store system-related information, and the rest stores the CLOB value. This method returns the amount of space used in the CLOB chunk to store the CLOB value.

Returns all the CLOB/NCLOB data as string.

For queries returning LOB columns, it can be more efficient to use fetchAsString, or fetchInfo instead of lob.getData().

This method checks to see if the CLOB was already opened using the input locator.

This method determines whether a CLOB instance is temporary.

This method gets the length of the specified CLOB. The length in characters is returned.

This method opens a CLOB in the indicated mode. Valid modes include read-only and read/write.

This method reads a piece of a CLOB and returns the specified amount into the buffer parameter, starting from an absolute offset from the beginning of the CLOB. If the input offset points past the End of CLOB, a NO_DATA_FOUND exception is raised.

Returns

a string that contains the characters actually read.

This method writes data into an internal CLOB, starting from an absolute offset from the beginning of the CLOB. The data is written from the buffer parameter. WRITE replaces (overwrites) any data that already exists in the CLOB at the offset.