Oracle ODBC Error

Oracle ODBC Error

Postby 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

Postby 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
RoniLev
 
Posts: 7
Joined: Sun 02 Mar 2014 21:04

Re: Oracle ODBC Error

Postby AlexP » Wed 23 Dec 2015 10:05

Hello,

Oracle doesn't support the DirtyRead transaction type.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to ODBC Drivers