Re: Stored Procedures and Tablespaces

Use 'triggers' (written in PL/SQL) on the tables the data is being originally inserted into. Look in the Oracle Application Developer's Manual (ships with the RDBMS).

MotoX.

Svein Ormel wrote in message <6on9gv$1hm$2_at_elle.eunet.no>...
>Hello all.
>
>I'm definitely no Oracle Guru. But my boss tells me to try any way.
>
>What I'm trying to do is creating to sets of tables, each in it's own
>tablespace (lets call them cactus and emms).
>The tables in the cactus tablespace is updated from an external
application,
>and each time this happens I would like to extract these new values and
>insert them into the tables in the emms tablespace. These new values will
>then in turn be used by another application, so what I'm really trying to
do
>is to create a datalink between two applications.
>The tables in the two tablespaces are not identical so it has to be a field
>by field approach.
>
>I'm just hoping that someone out there has a minute or two to explain how
to
>do this.
>
>Any help is greatly appreciated.
>
>Svein
>
>
>
>
Received on Fri Jul 17 1998 - 12:55:27 CEST