Oracle, ODBC and Constraints

From: Daniel Paetzold <daniel.paetzold_at_de.bosch.com>
Date: Wed, 29 Dec 2004 10:10:43 +0100
Message-ID: <cqtsaj$b5h$1@ns2.fe.internet.bosch.com>

Hello Oracle- Experts,

i'm using Oracle Enterprise Edition 9.2.0.4.0 on W2k SP4 and its ODBC-Drivers Version 9.02.00.00 together with Apache 1.3 (in Oracle included) and PHP.

The Problem Occurs when i try to commit the following SQL-statement: select "A2".* from "ALL_CONSTRAINTS" "A2" WHERE "A2"."OWNER"='OWN' AND "A2"."TABLE_NAME"='STRANGE'; While SQLPlus returns the full set of Constraints (15 result-rows), it seems that the ODBC-Driver only returns 8 of them. I have not found any logical reason for the missing lines, as they have nothing in common.

Are there any know Bugs? What can i do to get all resulting Lines?

Unfortunally i do have to use ODBC - and currently the whole Program gets stuck because of that tiny Problem.

Regards,
Daniel Received on Wed Dec 29 2004 - 03:10:43 CST