Oracle Objects for OLE
Release 9.2

Part Number A95895-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Compare (OraLOB) Method

Applies To

OraBLOB, OraCLOB

OraBFILE

Description

Compares the specified portion of the LOB value of an OraBlob or OraClob object (or OraBfile object) to the LOB value of the input OraBlob or OraClob object (or OraBfile object).

Arguments
Description
[in] srcLOB
Input OraBlob, OraClob or OraBfile object whose value is to be compared
[in] [optional]amount
An integer specifying the number of bytes or characters to compare. The default value of Amount is from the offset to the end of each LOB.
[in] [optional] Offset
An integer specifying the 1-based offset in bytes (OraBlob or OraBFILE) or characters (OraClob) in the value of this object. Default value is 1.
[in] [optional] srcOffset
An integer specifying the 1-based offset in bytes (OraBlob or OraBFILE) or characters (OraClob) in the value of the srcLob object. Default value is 1.
[out] IsEqual
A Boolean representing compare operation status.
Usage

IsEqual = OraBlob.Compare srcBlob, amount, Offset, srcOffset

IsEqual = OraClob.Compare srcClob, amount, Offset, srcOffset

IsEqual = OraBfile.Compare srcBfile, amount, Offset, srcOffset

Remarks

Returns true if comparison succeeds, and false otherwise.

If the amount to be compared causes the comparison to take place beyond the end of one LOB but not beyond the end of the other, the comparison fails. Such a comparison could succeed only if the amount of data from the offset to the end is the exactly the same for both LOBs.

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


 
Oracle
Copyright © 1994, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback