../E17727-04.epub /> ../E17727-04.mobi />

MatchPos (OraLOB/BFILE) Method


Returns the position of the nth occurrence of the pattern starting at the offset.


position = OraBlob.MatchPos pattern, offset, nth
position = OraClob.MatchPos pattern, offset, nth
position = OraBFile.MatchPos pattern, offset, nth


The arguments for the method are:

Arguments Description
[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.


This call is currently implemented by executing a PL/SQL block that uses DBMS_LOB.INSTR().