Re: Calling Java program from Oracle 8.0 Trigger

You need oracle version 8.1 or greater (8i) to use java stored procedures which can use sqlj, otherwise bhogak covers the other options.

"bhogak" <bhogak_at_yahoo.com> wrote in message news:97kdr9$o6n$1_at_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 Thu Mar 01 2001 - 07:14:19 CST