Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL Mystery : Bug in latest SQO32_73.DLL?
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