Devart Forums

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

Hello,

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

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

Hello,


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

Thanks so much !!!!
Daniele

When the new build will be available?

hello,

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