Retrieves the character position at which the specified search string begins within the CLOB value that this Clob object represents. The search for searchstr begins at position start.
Arguments
Argument | Description |
---|---|
searchstr | The string for which to search. |
start | The position at which to begin searching. The first position is 1. |
Return Value
If the search is successful, position() returns the position at which the search string begins; otherwise, position() returns a value of -1.
Exceptions
IF … | THEN position() throws an SQLException to … | |||
---|---|---|---|---|
there is an error accessing the CLOB value | indicate a failure while reading LOB data, setting the SQLException fields as follows:
|
|||
the searchstr argument is null -or- the value of the start argument is less than 1 |
indicate an invalid argument, setting the SQLException fields as follows:
|
|||
the JVM cannot allocate enough memory for the method to search for the specified string | indicate that available JVM heap memory has run out, setting the SQLException fields as follows:
|