Hello,
I had been using Delphi application with DOA 3.6. Oracle version was 10.1 with NLS_CHARACTERSET=UTF8.
There had been problem with changing numeric fields. Whenever user tried edit numeric field in client program
"Record is locked by another user" was returned even if there were no locked objects. Problem only
occured with numerical columns in Oracle.
I also made some tests on different server with Oracle 10.1, with NLS_CHARACTERSET=EE8MSWIN1250. Everything
was ok.
Recently, I upgraded DOA to version 4.0 to get ridd of locking problem. Problem disappeared, but
now I have even worse problems which happen only on Oracle with UTF8 characterset. Database containts
Lithuanian characters, maybe this is the reason..
The problem occurs when TOracleDataSet inserts record into the database. When record is inserted
fields are written into the database in wrong order!!!
For example record is to be inserted like this:
insert into my_table(id, field_1, field_2, field_3, ..... field_x)
values(1, value_1, value_2, value_3, ..... value_x)
but finally it is written into the table with fields in quite different order!!!
For example instead of
value_1 the record contains value_3, and instead of value_3 record contains value_7 and so on..
The order of inserted fields is random.
I captured SQL's in Oracle Monitor and sql inserting 1 record looks like this:
insert into my_table
(ID, FIELD_1, FIELD_2, FIELD_3, ... FIELD_X)
values
(:v1, :v2, :v3, :v6, :v7, :v8,..... :v_x)
returning rowid into :doa__rowid
Whereas in DOA 3.4 SQL looked like this:
insert into my_table
(ID, FIELD_1, FIELD_2, FIELD_3, ... FIELD_X)
values
(:ID, :FIELD_1, :FIELD_2, :FIELD_3,..... :FIELD_X)
It seems that in DOA 4.0 variables are named by "v" whereas in older version variables where named by
field names.
To conclude: currently records inserted to Oracle are totally random! I have no idea what is wrong.
Is it a matter of TOracleDataSet properties?
All problems take place on Oracle with UTF8 characterset,and with Lithuanian data in tables. Is it
supposed to be the reason?
Please help me with the problem,
Greetings,
Remek G
