Page 1 of 1
how to comunicate between sessions? multiuser TOraAlerter
Posted: Fri 10 Dec 2004 12:58
by Guest
Hi!
can anybody tell me how to send messages with the alert components of ODAC, i already sended pipes but they do not arrive at all sessions and sometimes there were completely lost...
how can i send alerts? odac help is to short in that case...
does anyone already builded a concurent multiuser software with odac?
bye
Posted: Fri 10 Dec 2004 16:20
by Paul
TOraAlerter uses DBMS_PIPE, DBMS_ALERT Oracle package for sending events. You can get information about pipes and alerts from oracle documentation.
Please see ODAC demo project Demos\Alerter\Alerter.dpr to know how to use TOraAlerter. Please try this demo project with TOraAlerter.EventType=etPipe and check your results. Please try this demo project with TOraAlerter.EventType=etAlert as a alternative method to send messages between sessions.
Posted: Mon 13 Dec 2004 11:33
by Guest
hi, iam getting an error in my project by calling stop routine or setting active property of the alert component to false...
i tried this in a new other short sample project and its works fine, but in my existing problem it fails with the following Debugger EORAError Exceptions:
translated:
ORA-06502: PL/SQL ... Stringbuffer is to small
ORA-06512: in "SYS.DBMS_ALERT", row 252
ORA-06512: in row 1
any ideas by what this could be caused...?
alerter settings:
Active true
AutoCommit true
Events "SWS_CHANGED"
EventType etAlert
Interval 2500
TimeOut 36000
ps.: the error occurs only when the SendEvent function was called...
Posted: Thu 16 Dec 2004 09:16
by Paul
We got your request and now examines the problem. Unfortunately now we couldn't give you any information. As soon as we solve the problem, we'll let you know.
Posted: Fri 17 Dec 2004 13:30
by Paul
We reproduced your problem and fixed it. This fix will be included in the
next ODAC build.