Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Callback (notification) with ODBC?

Re: Callback (notification) with ODBC?

From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: Wed, 27 Jan 1999 16:25:45 -0000
Message-ID: <78nem2$upe$1@hagen.cloud9.co.uk>


Try the DBMS_ALERT package, I've used this in PL/SQL and got some VC++ guys to implement it successfully.

You're client will need to register for an alert then check regularly to see if one has been sent.

On the server side you need to write a trigger to send the event when changes occur.

Stewart Burnett

Please remove 'nospam' from address when replying direct.

Omer Eisenberg <omereis_at_nist.gov> wrote in message news:36AF2D6E.A948EED1_at_nist.gov...
>Hi All,
>I'm writing a client-server application under NT with VC++ and MFC,
>using ODBC interface to Oracle.
>I would like the client software to be notified when some tables are
>changed. Can anyone please let me know how it is done?
>Thanks in advance,
>Omer.
>
>
>
Received on Wed Jan 27 1999 - 10:25:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US