Re: DBMS_ALERT - is it what it's cracked up to be?

Why don't you write yourself a C-Routine that listens for the specific Alert of your INSERT-Trigger.

If you do it this way, everything would be possible. e.g. Prompting actions, performing DML, aso

All you have to do is to register the specific alert in your PRO C/C++ code and wait for is (e.g. infinite loop)
If an event occurs your C-code can do what you want.

hth christoph Received on Wed Apr 26 2000 - 00:00:00 CDT