Oracle® Objects for OLE Developer's Guide 10g Release 1 (10.1) Part Number B10118-01 |
|
Applies To
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 |
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()