TOraAlerter exceptions

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Daniele Buttarelli
Posts: 56
Joined: Fri 02 Aug 2013 07:51

TOraAlerter exceptions

Post by Daniele Buttarelli » Tue 10 Sep 2013 14:59

RAD Studio XE4 Update1 + Mobile
ODAC 9.0.2
Oracle Database 11g Release 11.2.0.1.0

I have problems with TOraAlerter on iOS IPAD;

I execute a stored procedure asynchronously by starting an Oracle DBJob. At the end of stored procedure I put this instruction to inform client that execution is finished: DBMS_ALERT.SIGNAL( 'SYNC_DEVICE_COMPLETED', 'Completed' );

On the client I have a TOraAlerter with this configuration:

object OraAlerter: TOraAlerter
Events = 'SYNC_DEVICE_COMPLETED'
OnError = OraAlerterError
Session = dmMain.OraSession
EventType = etAlert
OnEvent = OraAlerterEvent
OnTimeOut = OraAlerterTimeOut
end

In the OraAlerterEvent I put this code:
if Event = 'SYNC_DEVICE_COMPLETED' then begin
MessageDlg( 'Sync completed!', TMsgDlgType.mtInformation, [ TMsgDlgBtn.mbOK ], 0 );
FSyncFinished := True;
end;

During execution I get an Access Violation on MessageDlg...
If I try with OraAlerter.Stop I get this exception:
"Thread Error: Resource deadlock avoided (11)".

How can I solve this problem?
Thanks.
Daniele
Last edited by Daniele Buttarelli on Wed 11 Sep 2013 10:12, edited 1 time in total.

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

Re: TOraAlerter exceptions

Post by AlexP » Wed 11 Sep 2013 08:17

Hello,

Thank you for the information, we have reproduced the problem and will investigate the reasons for this kind of behaviour.

Daniele Buttarelli
Posts: 56
Joined: Fri 02 Aug 2013 07:51

Re: TOraAlerter exceptions

Post by Daniele Buttarelli » Fri 13 Sep 2013 06:49

Any news about my problem?
Thanks.
Best regards.
Daniele

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

Re: TOraAlerter exceptions

Post by AlexP » Fri 13 Sep 2013 07:04

Hello,


We have already fixed the problem, the fix will be included to the next version of ODAC, that will be released next week.

Daniele Buttarelli
Posts: 56
Joined: Fri 02 Aug 2013 07:51

Re: TOraAlerter exceptions

Post by Daniele Buttarelli » Fri 13 Sep 2013 07:07

Thanks so much !!!!
Daniele

Daniele Buttarelli
Posts: 56
Joined: Fri 02 Aug 2013 07:51

Re: TOraAlerter exceptions

Post by Daniele Buttarelli » Tue 17 Sep 2013 14:14

When the new build will be available?

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

Re: TOraAlerter exceptions

Post by AlexP » Thu 19 Sep 2013 09:00

hello,

We are finishing the final RAD Studio XE5 compatibility test and are are going to release the new versions today

Post Reply