Re: Can a server notify a client when something has changed?

I read some stuff about the DBMS_ALERT and DBMS_PIPE packages. DBMS_ALERT seems to be the best one for my me. With DBMS_ALERT you can "send" a message to all connected sessions. Then it is the responsability of the client to "read" all message. I think I still need a timer here. The message can even hold info about the cahgned row: i.e. unique key or rowid.

Arie Mars <arie_at_pca-online.nl> schreef in berichtnieuws 8sguvu$dcqap$1_at_reader3.wxs.nl...
> Hello,
>
> I'm using Oracle 8i and Forms5 on Win9x-clients.
>
> On the client I have a calender view showing employees and there
> appointments. Now I like to notify a certain client when his agenda has
 been
> changed by another user, i.e. a new appointment.
>
> My first solution is to use a timer on each client-machine and check the
> database at certain intervals, lets says every few seconds.
>
> It would be nicer if the server notifies the client that something has
> changed.
>
> Any ideas?
>
> Arie Mars
> arie_at_pca-online.nl
>
>
>
Received on Thu Oct 19 2000 - 01:43:54 CDT