Oracle® Objects for OLE Developer's Guide 11g Release 2 (11.2) for Microsoft Windows Part Number E12245-01 |
|
|
View PDF |
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()
.