Retrieves all or part of the CLOB value that this Clob object represents as a string of characters.
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.
Syntax
getSubString(long pos, int length)
Syntax Elements
- pos
- The position of the first character in the CLOB value to be extracted.
- length
- The number of consecutive characters to be copied.
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:
|
|||