A question about Oracle Database from a trigger developer

From: Weidong Yu <wyu_at_empress.com>
Date: Mon, 06 Nov 2000 21:21:06 +0000
Message-ID: <3A0720C2.9909346C@empress.com>

Hi,

I met a problem when I called a remote stored procedure in a trigger. The trigger will run after inserting a record in a table. In the tigger I used DB link to call a stored procedure, but the message showed me the distributed operation fail. The same remote procedure works fine for me if I called it from another stored procedure. Did anybody have any ideas what kind of configurations for triggers so I can run a procedure through a dblink? Or is Oracle incapable to do so? I tried Oracle versions 7 and 8.15; both don't work. Please give me a hand to yiwen_zhu_at_excite.com . Thank you very much.

The trigger:
CREATE OR REPLACE TRIGGER Post_Ins

   AFTER INSERT
   ON Post
   FOR EACH ROW
BEGIN
        remote_proc_at_db_link(:new.postid); END;
/

If I call it in the following stored procedure, it works fine. CREATE OR REPLACE procedure test
as
BEGIN
remote_proc_at_db_link(12345);
END;
/
Received on Mon Nov 06 2000 - 15:21:06 CST