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
Oracle ODBC Error
Re: Oracle ODBC Error
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
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
Hello,
Oracle doesn't support the DirtyRead transaction type.
Oracle doesn't support the DirtyRead transaction type.