Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
Some body told that we can't use VIEW in an event alert. So is there any other way to do it?
Please suggest me the alternative way.
It seems like we cannot use view for 'Event Alert'. https://docs.oracle.com/cd/E18727_01/doc.121/e12951/T338646T338650.htm#I_ex2Ddevt
May i know you requirement?, ideally alert was built to monitor a table for insert and update operations.