Re: insert data from other instance

> I have 2 instaces "A" and "B"
>
> In the instance "A" I have a table TABLE_A and in the instace "B" the
> table TABLE_B.
>
> I need to put a trigger that when I insert data in TABLE_A the event
> executes "something" (store procedure) and insert data in the
> instance "B" in the table TABLE_B
>
> Another information: TABLE_A is diferent from TABLE_B , this produce
> that I need to manipulate info in the store procedure triggred and put
> some values in hardcode or from another tables.
>
> I have Oracle 8i and I need an example code if it is posible

The best way to handle this from my experience is to use a stored procedure, or package, to perform all inserts into all tables in both instances. In fact, I never let anyone connect directly to a table anymore. Pass the values to the stored code and let it slice it, dice it, and distribute it.

Daniel A. Morgan Received on Wed Jan 17 2001 - 00:22:11 CST