Re: How to invoke stored procedures from another instance?

For this AQ or possibly streams in 9i would be the best, but there is a bit of work to get either set up and functioning the way you want. The big benefit is done right you cant lose a message from one system to the other.
This is fundamentally EAI integration without the messaging server. You could effectively though have an EAI adaptor for your application with a bit of additional thought

Cheers

--


=================================================

Peter McLarty               E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048


=================================================

"If people did not sometimes do silly things, nothing intelligent would 
ever
get done." 
   - Ludwig Wittgenstein


=================================================

Mincom "The People, The Experience, The Vision"



=================================================


This transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please 
delete it and notify the sender. The contents of this e-mail are the 
opinion of the writer only and are not endorsed by the Mincom Group of 
companies unless expressly stated otherwise. 






"Ranganath K" <Ranganath_K01_at_infosys.com>
Sent by: ml-errors_at_fatcity.com
28/08/2003 08:15 PM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        How to invoke stored procedures from another instance?


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
 
1. Trigger on the table invoking the procedures of the other instance
2. Using dbms_alert
3. 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 [RK-FM8B9B3]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Peter.McLarty_at_mincom.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).