How to catch exceptions occured while TOraQuery.Execute?

[Guest]

hi there,

i wrote a daemon using the toraquery class to insert data in a database. if the database goes down or the session dies for some reason i want to catch the EOraError Exceptions.

code is similar to:

try
toraquery.Execute;
Except on EOraError do begin
do some error handling
end;

i can see that an execption occurs in the delphi debugger when i kill the oracle session, but for any reason the exception is not raised and no error handling is done. can you suggest any way to catch the exception?

thx and br, klaus eckhardt.

[Alex]

You can use TOraErrorHandler component or TOraSession.OnError event handler for such tasks.

[Guest]

thank you for your suggestion. it was not so simple, but at last it works.
br, klaus.