I use DBlinks with triggers frequently, and haven't encountered any problem.
My database links are Public database links. (This saves the need to specify
a username and password).
I have public synonyms on all my tables and I always refer to these.
Mike Haegele wrote in message ...
>Hello,
>
>I've tried to use a db link within a trigger and it doesn't work.
>Optionaly I've wrote a stored procedure with the db link call and used
>this procedure with the trigger and it doesn't work too.
>If I test the db link with a single sql statement it works.
>
>Has anybody any suggestion?
>
>Thanks in advance,
>
>Mike
Received on Mon Oct 22 2001 - 05:09:36 CDT
