Re: Database server callbacks to clients across SQLNET

In article <746fv5$6eo$1_at_nnrp1.dejanews.com>,   ed_at_kideys.com wrote:
> Hi everyone,
>
> Please help me with the following situation.
>
> We have an intranet where we have a DEC VAX 3100 running VMS where we have
> the Oracle version 7.1.3 database server. The database clients will be pcs
> running Oracle version 8.0 or 7.3. The client/server communications across
> the network is handled by Oracle SQLNET version 2.1.3.
>
> There must be a way for the Oracle server to broadcast each change in the
> database to the client PCs that need to know about them. The database server
> is aware of the clients updating the database so it must also be able to tell
> the clients of any changes.
>
> Any help appreciated. Thank you.
>
> Ed Kideys
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Have you checked DBMS_ALERT package? It does exactly what you need.

--
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 03 1998 - 13:03:40 CST