Oracle-L: How to invoke stored procedures from another instance?

From: Ranganath K <Ranganath_K01_at_infosys.com>
Date: Thu, 28 Aug 2003 02:15:09 -0800
Message-ID: <F001.005CDAB4.20030828021509@fatcity.com>

Hi listers,

Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options we looked at are

Trigger on the table invoking the procedures of the other instance
Using dbms_alert
Some kind of polling mechanism

Triggers we would like to avoid. Options we are left with are dbms_alert and polling mechanism.

Is it possible to use dbms_alert in this case? If yes how?

Can you think of some kind of polling mechanism which will satisfy the need of real time communication? Updates on the table is done at a very fast rate, hence processing should also be at a fast rate.

Any help in this regard is very much appreciated.

Thanks and Regards,

Ranganath

MailFiler <http://www.mailfiler.com> [RK-FM8B9B3]

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ranganath K
INET: Ranganath_K01_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 28 2003 - 05:15:09 CDT