Retrieves all or part of the CLOB value that this Clob object represents as a string of characters.
Arguments
Argument | Description |
---|---|
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. |
Return Value
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.
Exceptions
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 -or- 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:
|