Hi, Is there any possibility to capture an oracle trigger event in Java application that is using that d/b.either by using Observable class or by other means. Respond with the possibility needed urgently.
Well, good question. Not sure I know the anzwer, but considering that you can have Java classes being used in a PL/SQL Stored Proceudre, I assume you could simulate this event capture where your Java Object sends out a JMS Asynchronous message, which "triggers" the event in Java, where your Java Objects are subscribers to that Queue, and therefore will know when that Oracle Stored Procedure is run.
But that might be the long way around, if something does already exist.
Originally posted by Bill Johnston: I wonder if Menon might have something on that in his new book?
I am afraid not This is kind of specific requirement. The only way I can think of is to use JMS like Mark suggested. The trigger would result in a JMS message to the application. (I am no JMS expert, btw)
May I ask what the real business requirement is in this case?
subject: How to capture the event in Java when trigger is fired in Oracle