Page 1 of 1

Oracle ODBC Error

Posted: Mon 21 Dec 2015 20:52
by RoniLev
Hello all
I use Delphi XE2 with BDE.
I access Oracle 11g using Devart ODBC for Oracle.
my oracle CharSet is non Unicode (AMERICAN_AMERICA.WE8ISO8859P1)
I got this error when running simple Update sql command.
"unsupported transaction isolation level"
Any ideas?
Roni

Re: Oracle ODBC Error

Posted: Tue 22 Dec 2015 20:29
by RoniLev
I found the problem.
It was a parameter TransIsolation in Tdatabase component.
It was set to tiDirtyRead .
I Changed it to tiReadCommited and it works fine.
Roni

Re: Oracle ODBC Error

Posted: Wed 23 Dec 2015 10:05
by AlexP
Hello,

Oracle doesn't support the DirtyRead transaction type.