Re: Oracle Listeners

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:30:44 GMT
Message-ID: <tkbqe6i9662v58@beta-news.demon.nl>

"Francesco Marchioni" <fmarchioni_at_libero.it> wrote in message news:gsl17.286$eB4.7788_at_news.infostrada.it...
> Hi all,
> I have heard about Oracle listeners. I wonder if it's possible
> to notify to an external application (in my case a Java application)
> when rows are inserted/updated. Anybody knows how to do it?
> Thanks
> Francesco
>
>
>

Listeners serve incoming requests from clients to connect to a database. As soon as a dedicated or shared server process has been dispatched, the activity of the listener for that client stops. So: no you can't use a listener for this purpose as the listener is not listening to the database but to clients.

Basically you would need to develop a trigger on every table, communicating by means of pipes with the Java client.
I have a feeling this will result in an enormous amount of overhead, and it will bring your application down to a crawl.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 21 2001 - 16:30:44 CDT