Hi guyz , is there any way by which a trigger can interact with JDBC ? I want to check the database each time its updated and if some condition is violated , the info((row from table which has voilated some rule) is passed to java code which can then take necessary action . Can anyone help me out in this because i am not aware of any way by which a trigger can interact with java code . Regards, Nikhi
Hii Vishal , thanks for your reply .But i think you didn't get my point ,actually my title is misleading . I don't want to call trigger from anywhere .They will keep operating on the database . But what i want is as soon as some condition is violated (ie when the updated value of one of the column exceeds the limit) , i need to call the java program and need to pass that particular row to java .My java program will then take the control and take some necessary actions . Can you help me out in this ??