Re: Calling external Java from Oracle 8.0.5

From: Cristian Veronesi <c.veronesi_at_crpa.it>
Date: Thu, 11 Oct 2001 12:45:34 +0200
Message-ID: <3BC5784E.AD701A49@crpa.it>

Pascal Byrne wrote:

> I need to create a trigger that is capable of calling a piece of Java
> code from Oracle 8.0.5.Does anyone know of any technique or third
> party product that will allow this?

You can write a listener in Java that listens to messages sent by the trigger through a DMBS pipe and then performs some action. Give a look at the documentation of PL/SQL package DBMS_PIPE. The sample listener is written in Pro*C, but it's even easier to implement a similar one using Java and JDBC.

-- 
Cristian Veronesi ><((((º> http://www.crpa.it

"I'm doing a (free) operating system (just a hobby, won't be big and
professional like gnu)..." [Linus Torvalds, comp.os.minix, 25-08-1991]

Received on Thu Oct 11 2001 - 05:45:34 CDT