Re: Can ORACLE triggers talk to non-RDB processes?

hi Bart,

have a look at DBMS_ALERT and DBMS_PIPE packages.

If your GUI is an Oracle Forms process then a combination of WHEN_TIMER_EXPIRED trigger and DBMS_ALERT calls would enable you to poll for an occurrence at suitable time intervals.

If you need immediate notification you may have to consider a combination of DBMS_PIPE notifying a sleeping process.

All depends on your platform, interfaces, available tools and notification turnaround needs.

Hope it's helpful

regards

Rod Corderey

Lane Associates
Lane_Associates_at_Compuserve.com
http://www.Lane-Associates.com   

Bart Jenkins wrote:
>
> All,
> I don't have much experience with triggers with RDB's. Can someone tell me
> if it is possible to have, say a GUI process be notified via a trigger event
> on a CRUD activity on a row on the RDB?
>
> Thanks,
> Bart Jenkins
Received on Wed Jul 15 1998 - 09:01:45 CEST