Re: Oracle DBMS_ALERT

I can think of two solutions:

1. Submit your procedure through DBMS_JOB
2. Write a daemon (in Pro*C or whatever language your prefer)

The first is probably the easiest way.

Cheers,
Gollum

On Fri, 04 Feb 2000 21:08:22 GMT, jchickanosky_at_my-deja.com wrote:

>
>
>I have a stored procedure which does nothing more than wait for a
>DBMS_ALERT. When it gets the one it expects, it calls another stored
>procedure. It works fine when I open a SQLPlus session and run it. How
>can I get this to always be running in the background? When I close my
>SQLPLus session, obviously it stops.
>
>Thanks in advance,
>-Joe Chickanosky
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Feb 04 2000 - 16:06:10 CST