Hi,
I encountered problems when working with lower case column names in version 1.0.0.15.57. Can anybody confirm this problem?
This is what I have done to reproduce the error:
1.1 create a table "test" in the tree view under section "Tables"
1.2 add the column "test"
1.3. insert data in the new table
My result message in the "data-editor log" window is:
INSERT INTO "ACCESS"."test" (test) VALUES ('fhdfgdfg')
One error saving changes to table "ACCESS"."test":
Row 1: ORA-06550: Zeile 1, Spalte 35:
PL/SQL: ORA-00904: "TEST": ungültiger Bezeichner
ORA-06550: Zeile 1, Spalte 7:
PL/SQL: SQL Statement ignored
As workaround I tried to create a table with upper case letters and then changed one column name to lower case afterwards. The result is similar:
INSERT INTO "ACCESS"."TEST" (col1, COL2) VALUES ('123', 'opkl')
One error saving changes to table "ACCESS"."TEST":
Row 1: ORA-06550: Zeile 1, Spalte 36:
PL/SQL: ORA-00904: "COL1": ungültiger Bezeichner
ORA-06550: Zeile 1, Spalte 7:
PL/SQL: SQL Statement ignored
Can anybody help me with this?
Thanks in advance.