how to comunicate between sessions? multiuser TOraAlerter

Guest · Post by **Guest** » Fri 10 Dec 2004 12:58

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

Paul · Post by **Paul** » Fri 10 Dec 2004 16:20

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.

Guest · Post by **Guest** » Mon 13 Dec 2004 11:33

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...

Paul · Post by **Paul** » Thu 16 Dec 2004 09:16

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.

Paul · Post by **Paul** » Fri 17 Dec 2004 13:30

We reproduced your problem and fixed it. This fix will be included in the
next ODAC build.