Oracle ODBC Error

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
RoniLev
Posts: 7
Joined: Sun 02 Mar 2014 21:04

Oracle ODBC Error

Post by RoniLev » Mon 21 Dec 2015 20:52

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

RoniLev
Posts: 7
Joined: Sun 02 Mar 2014 21:04

Re: Oracle ODBC Error

Post by RoniLev » Tue 22 Dec 2015 20:29

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Oracle ODBC Error

Post by AlexP » Wed 23 Dec 2015 10:05

Hello,

Oracle doesn't support the DirtyRead transaction type.

Post Reply