Re: Calling external Java from Oracle 8.0.5

From: Pascal Byrne <pbyrne_at_icada.net>
Date: Thu, 11 Oct 2001 14:55:16 +0200
Message-ID: <3BC596B4.1050702@icada.net>

I'll give that a try.

Thanks.

Cristian Veronesi wrote:

> 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.
>
>
Received on Thu Oct 11 2001 - 07:55:16 CDT