Skip Headers
Oracle® Objects for OLE C++ Class Library Developer's Guide
10g Release 2 (10.2)

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

Compare Method

Applies To

OBlob

OClob

OBfile

Description

Compares the specified portion of the LOB value of an OBfile, OBlob, or OClob object to the LOB value of the input OBfile, OBlob, or OClob object.

Usage

bool Compare(const OBlob& src_lob, unsigned long amount, unsigned long dst_offset = 1, unsigned long src_offset = 1) const throw(OException)

bool Compare(const OClob& src_lob, unsigned long amount, unsigned long dst_offset = 1, unsigned long src_offset = 1) const throw(OException)

bool Compare(const OBfile& src_lob, unsigned long amount, unsigned long dst_offset = 1, unsigned long src_offset = 1) const throw(OException)

Arguments

Arguments
Description
src_lob
Input OBlob, OClob or OBfile object whose value is to be compared.
amount
An integer specifying the number of bytes or characters to compare.
dst_offset
An integer specifying the 1-based offset in bytes (OBlob or OBFILE) or characters (OClob) in the value of this object. Default value is 1.
src_offset
An integer specifying the 1-based offset in bytes (OBlob or OBFILE) or characters (OClob) in the value of the src_lob object. Default value is 1.

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