Devart Forums

my oracle version is 10.2.0.4
delphi 2010.

ODAC in direct mode.

create table USERDATA
(
USERID NUMBER(22),
STIME DATE,
ETIME DATE,
BZ VARCHAR2(10)
)

with cx do
begin
close;
SQL.Clear;
SQL.Add('UPDATE USERDATA SET ETIME=SYSDATE, BZ=:BZ');
SQL.Add('WHERE USERID=:USERID');
ParamByName('USERID').Asstring:= '48';
ParamByName('BZ').AsString := 'logout';
Execute; // show unknown error 1!
end;

if changed to
with cx do
begin
close;
SQL.Clear;
SQL.Add('UPDATE USERDATA SET ETIME=SYSDATE, BZ=:BZ');
SQL.Add('WHERE USERID=:USERID');
ParamByName('USERID').Asinteger:= strtoint('48');
ParamByName('BZ').AsString := 'logout';
Execute;
end;
It works fine!

but in SELECT , INSERT ParamByName('USERID').Asstring:= '48' works fine.

We have reproduced this problem, and we are working on it. You will be notified when we fix the problem.

odac 6.80.0.48 still has this bug!

We do have the same problems and are waiting for a solution...

We have not fixed this problem yet. We will fix it in the nearest future.

Have you fixed this problem yet?

We will fix this problem in the next ODAC build.

The problem still in 5.90.0.53

hello?

The problem still in 5.90.0.55

Please contact us by e-mail support*devart*com. We will send us the new version for testing.