When i manually insert a record into a table then my trigger executes by updating another table. However, when a record is inserted into that same table through a web service application the trigger doesn't fire off. How can I fix this?
create or replace trigger PDF_FILE
AFTER insert ON table_A
FOR EACH ROW
update table_B set file='Y' where :new.sti_id=table_B.id and :new.type=752;