bug with quoted object type names
Posted: Wed 23 May 2012 15:17
Hello,
If I create this type and table:
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
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");The problem is that function QuotedOCIName in OraClasses is adding double quotes when they are already there.
-John