update of remote Table in a trigger failes

From: Sebastian Scholz <e9926043_at_student.tuwien.ac.at>
Date: Thu, 16 Aug 2001 15:44:09 GMT
Message-ID: <3b7be7a4.4008343@news.tuwien.ac.at>

Hello!

I've got a rather complex problem:

We're having two Oracle Databases (8I and 7) which are linked together with a public database link defined in the 8I db. The Link works well and I'm able to update a Table in the 7 Database from sqlplus wich runs with Oracle 8I.

Now we have an application which uses the oracle 8I database and the same username I used prior in sqlplus to log on to the 8I DB. When the App changes a specific table, exactly the same update statement should be issued against a table in the 7 DB. So I installed a trigger, but I'm getting always an exception.

Why is it possible in the console an UPDATE Statement works and not in a Trigger?
In Development, we're using 8.0.5 and the Procedure worked well, at the customer site, however, we're using 8.1.6.

Thank you,

Sebastian Received on Thu Aug 16 2001 - 10:44:09 CDT