Retrieves all or part of the CLOB value that this Clob object represents as a string of characters.
|pos||The position of the first character in the CLOB value to be extracted.
The first character is at position 1.
|length||The number of consecutive characters to be copied.|
The result string contains up to length consecutive characters from the CLOB value designated by this Clob object, starting with the character at position pos.
If the value of pos + length - 1 is larger than the length of the CLOB in characters, the length of the resulting string is less than length.
|IF …||THEN getSubString() throws an SQLException to …|
|there is an error accessing the CLOB value||indicate a failure while the reading from Clob data, setting the SQLException fields as follows:
|the value of the pos argument is less than 1
the value of the length argument is negative
|indicate an invalid argument, setting the SQLException fields as follows:
|the value of the length argument is too large for the current JVM to allocate the required memory for this function||indicate that available JVM heap memory has run out, setting the SQLException fields as follows: