how to capture errors occured in orasession

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
davidman
Posts: 1
Joined: Thu 31 Aug 2006 09:01

how to capture errors occured in orasession

Post by davidman » Thu 31 Aug 2006 09:11

here is my code, the colunm named col in table aaa is set to primary key

with oraquery1 do
begin
try
close;
sql.clear;
sql.add('insert into aaa(col1) values (1)');
execute;
except
on E:Eoraerror do
begin
orasession1.rollback;
showmessage(e.message);
end;
end;

my question is when i insert same value in table aaa,the code should tell me the message,but it can't work

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 31 Aug 2006 13:16

We cannot reproduce the problem. If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

Post Reply