TOraAlerter exceptions
-
- Posts: 56
- Joined: Fri 02 Aug 2013 07:51
TOraAlerter exceptions
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
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.
Re: TOraAlerter exceptions
Hello,
Thank you for the information, we have reproduced the problem and will investigate the reasons for this kind of behaviour.
Thank you for the information, we have reproduced the problem and will investigate the reasons for this kind of behaviour.
-
- Posts: 56
- Joined: Fri 02 Aug 2013 07:51
Re: TOraAlerter exceptions
Any news about my problem?
Thanks.
Best regards.
Daniele
Thanks.
Best regards.
Daniele
Re: TOraAlerter exceptions
Hello,
We have already fixed the problem, the fix will be included to the next version of ODAC, that will be released next week.
We have already fixed the problem, the fix will be included to the next version of ODAC, that will be released next week.
-
- Posts: 56
- Joined: Fri 02 Aug 2013 07:51
Re: TOraAlerter exceptions
Thanks so much !!!!
Daniele
Daniele
-
- Posts: 56
- Joined: Fri 02 Aug 2013 07:51
Re: TOraAlerter exceptions
When the new build will be available?
Re: TOraAlerter exceptions
hello,
We are finishing the final RAD Studio XE5 compatibility test and are are going to release the new versions today
We are finishing the final RAD Studio XE5 compatibility test and are are going to release the new versions today