Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Mystery : Bug in latest SQO32_73.DLL?

SQL Mystery : Bug in latest SQO32_73.DLL?

From: Tim Romano <tim_at_superstream.net>
Date: Tue, 05 May 1998 18:09:33 -0400
Message-ID: <354F8E1D.ABE319A2@superstream.net>


Running Oracle 7.3 Workgroup for NT Server.

MyTable T has these columns:

ID	VARCHAR2(3)
AGENT	VARCHAR2(5)

select * from MyTable T
where T.ID = '059'
and T.AGENT = '1111'

returns null set. BUT

select * from MyTable T
where T.ID = '059'
and T.AGENT = 1111

returns many rows.

Am I missing something very simple? Both columns are VARCHAR2.
Query executed from SQL Plus 3.3. Query also executed from TOAD.
Query also executed from MS-Access via ODBC. All three tools yield identical results.

The only thing that has changed on our system was the installation today of Oracle's latest ODBC driver for 32-bit Windows, and the existing SQO32_73.DLL file was replaced as part of the installation.

TIA,
Tim Received on Tue May 05 1998 - 17:09:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US