Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

MatchPos (OraLOB/BFILE) Method

Applies To

OraBLOB, OraCLOB

OraBFILE

Description

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

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
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()