Firing a trigger in a child block
523510Sep 6 2006 — edited Sep 6 2006I am currently running a post-change trigger in a block to update fields within the block i.e.
Declare
BEGIN
Select FTS.FTS_STATUS_FLASK_DESC into :TXT_STATUS
from FTS_NEW.FTS_STATUS_FLASK fts
Where FTS.FTS_STATUS_FLASK_ID = :FTS_FLASK_STATUS_ID;
--:TXT_STATUS := status_value;
END;
I have other fields in other blocks. I fire a query after the user has entered the first value into the first block of the form and this updates data in various blocks.
Unfortunately because I am not in all the blocks I cannot use post triggers when firing the select statements for values in the other blocks. Is there a trigger I can use to fire the select statements in other blocks.
I have tried referencing the other blocks as 'table.fieldname =:block2.text_field' from the post-change trigger but this throws another oracle exception. I have also tried using triggers at form level such as On-Populate-Details but this also has no effect. I am fairly new to oracle and realise there may be a fairly obvious solution to this problem, does anyone know what it is. Thanks