Returns a copy of the specified substring in the CLOB based on the given starting position and the number of characters to copy.

public java.lang.String getSubString(long pos,
                                     int length)

Parameters

pos

The first character of the substring to be extracted. The first character is at position 1.

length

The number of consecutive characters to be copied.

Return Value

A string that is the specified substring in the CLOB.

Exceptions

SQLServerException

Remarks

This getSubString method is specified by the getSubString method in the java.sql.Clob interface.

Trying to get zero characters from a null or zero-length CLOB returns an empty string. Trying to get any length of characters at any position other than position 1 in a zero-length CLOB will cause a position exception to be thrown.

See Also