Distributed Transaction Over Encrypted Columns Is Fetching Wrong Results (Doc ID 1308709.1)

Last updated on JULY 31, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

A distributed query[using database link] over encrypted columns may fetch incorrect results or no results .

For example :
SELECT gvc.card_no,fmx.mcard_no, fmx.card_no FROM gvc,gct,fmx WHERE gvc.acct_no = '1234567890' AND gvc.bin = gct.bin AND gvc.card_type = gct.type AND gvc.card_no = fmx.mcard_no
AND gct.category in ('VISA','MASTER') AND (SELECT p.cancellation_letter_date FROM pci@pcard p WHERE p.card_number = fmx.card_no) >= (SELECT sysdate - 1000 FROM dual)

No Rows Retuned

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms