Oracle Triggers Query..
Posted
by AGeek
on Stack Overflow
See other posts from Stack Overflow
or by AGeek
Published on 2010-05-19T03:30:48Z
Indexed on
2010/05/19
4:40 UTC
Read the original article
Hit count: 238
Lets consider a Table STUD and a ROW-Level TRIGGER is implemented over INSERT query.. My scenario goes like this, whenever a row is inserted, a trigger is fired and it should access some script file which is placed in the hard disk, and ultimately should print the result. So, is this thing is possible? and if yes, then this thing should exist in dynamic form, i.e. if we change the content of script file, then the oracle should reflect those changes as well.
I have tried doing this for java using External Procedures, but doesn't feel that much satisfied with the result that i wanted.
Kindly give your point-of-view for this kind of scenario and ways that this can be implemented.
© Stack Overflow or respective owner