How can I write a trigger or function which will notify
a java object about a particular event on a database table.
First of all is it possible to refer any java object through SQL
OK, the way we do this is with DBMS_ALERT on the DBMS which is fired whenever you need to send a message to a Java client which has registered an interest in it. Alternatively you can poll the database but the DBMS_ALERT method is much cleaner.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.