bug with quoted object type names

[jdorlon]

Hello,

If I create this type and table:

Code: Select all

CREATE OR REPLACE TYPE "PatientX" AS OBJECT ( 
  ID NUMBER(38), 
  LAST_NAME VARCHAR(200), 
  FIRST_NAME VARCHAR(200) 
);

CREATE TABLE HAS_PATIENTX
( COL1  NUMBER,
  COL2  "PatientX");

then put "select T.Rowid, T.Col1, T.Col2 from HAS_PATIENTX T" in a TSmartQuery and execute it, I get this error: OCI-22303: type "JDORLON".""PatientX"" not found

The problem is that function QuotedOCIName in OraClasses is adding double quotes when they are already there.

-John

[AlexP]

Hello,

Thank you for the information.
We've reproduced and fixed the problem.
This fix will be included in the next build.

[AlexP]

hello,

The new ODAC version 8.2.7 including this fix is already available at our site

[jdorlon]

Thank you Alex.