Applies To
OraBLOB, OraCLOB
OraBFILE
Description
Returns the position of the nth occurrence of the pattern starting at the offset.
Arguments
[in] pattern
A String for CLOB or Byte Array for BLOB or BFILE that is searched for in the
LOB.
[in] Offset
The starting position in the LOB or BFILE for the search.
[in] nth
The occurrence number
Usage
position = OraBlob.MatchPos pattern, offset, nth
position = OraClob.MatchPos pattern, offset, nth
position = OraBFile.MatchPos pattern, offset, nth
Remarks
This call is currently implemented by executing a PL/SQL block that utilizes
DBMS_LOB.INSTR()