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

Home -> Community -> Usenet -> c.d.o.server -> Triggered update on DBLinked Table

Triggered update on DBLinked Table

From: Olivier TOUSSET <info_at_morren.com>
Date: Wed, 03 Mar 1999 20:03:14 +0100
Message-ID: <36DD8772.2BF825C6@morren.com>


Hi,

We can update a remote table using a database link But the same update command in a trigger doesn't work. In the trigger we have also 2 select commands using the same DBLink.

What's amazing is that we DON'T receive any oracle errors during the trigger
execution.

We have tested the same situation on two others test NT PCs and it works.

But now, we are working on a Unix PC to a NT PC. Do we need some extra privileges, do we need to activate some features.

Any ideas or suggestions are welcome. Thank.

                                                            Eric TOUSSET


info_at_morren.com Received on Wed Mar 03 1999 - 13:03:14 CST

Original text of this message

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