Bug Outer Join Oracle OLE DB

From: Etienne <etienne.lesueur_at_wanadoo.fr>
Date: Wed, 17 Jul 2002 15:37:30 +0200
Message-ID: <ah3ru9$5fu$1@wanadoo.fr>

Hello,

I think there is a bug in the latest version 8.1.7.3 of Oracle OLEDB Driver.

When I try to execute the following query in SQL*Plus :

SELECT BA.IDPIECE , BAECRGEN.ECG_LIGNE ECR_LIGNE , BAECRGEN.PIE_DATE , BAECRGEN.LIBELLE01
FROM BAPIECES BA, BAECRGEN
WHERE BA.IDPIECE = 999 AND BA.IDPIECE=BAECRGEN.IDPIECE (+) ; I retrieve 1 row (and it's right).

When I excute the same query via the OLEDB Driver, I retrieve no rows !!!!!

If there's anyway to workaround this problem ?

Many Thanks.

Etienne. Received on Wed Jul 17 2002 - 08:37:30 CDT