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

Filed under:
|

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

Related posts about Oracle

Related posts about triggers