Re: Calling Java program from Oracle 8.0 Trigger

From: bhogak <bhogak_at_yahoo.com>
Date: Wed, 28 Feb 2001 20:54:12 -0600
Message-ID: <97kdr9$o6n$1@bob.news.rcn.net>

I am not sure if these are "better", but they are alternatives: 1. As of Oracle 8, I think you can create a stored procedure which executes an external C program. You can call the C program from your trigger and let the C program execute your Java program. 2. Using dbms_pipe, send a message from the trigger and the let the Java program (listener) execute after receiving the pipe.

bhogak.

Ravi Kumar <ravik_at_luc.com> wrote in message news:Xns9056C4437CBBCraviklucentcom_at_135.7.153.101...
> Folks,
> I have a requirement, wherein a external java program would have to be
> called on a trigger execution (Oracle8.0, solaris2.6), passing the result
of
> the trigger to the java program. I can think of a solution wherein the
trigger
> would write to a temprory table, which would be polled by another java
program
> to obtain the result. Can any one help me with a better solution to this
> problem. I am open to writing the trigger in PL/SQL or SQLJ to solve this
> problem in a single step.
>
> Ravi
Received on Wed Feb 28 2001 - 20:54:12 CST