MatchPos (OraLOB/BFILE) Method

Applies To

Description

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

Usage

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

Arguments

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.

Remarks

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