Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Firing a trigger in a child block

523510Sep 6 2006 — edited Sep 6 2006
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2006
Added on Sep 6 2006
1 comment
237 views