Retrieves the byte position at which the specified byte array pattern begins within the BLOB value that this Blob object represents. The search for pattern begins at position start.
|pattern||The byte array containing the pattern for which to search.|
|start||The position at which to begin searching.
The first position is 1.
If the search is successful, position() returns the position at which the pattern appears; otherwise, position returns a value of -1.
|IF …||THEN position() throws an SQLException to …|
|there is an error accessing the BLOB value||indicate a failure while reading LOB data, setting the SQLException fields as follows:
|the value of the pattern argument is null
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 pattern||indicate that available JVM heap memory has run out, setting the SQLException fields as follows: