formsoracle-databasetriggersoracle10glov

Post query trigger not firing after LOV population in oracle forms 10g

I have a master detail form in which details in a second block are displayed based on the first block. The problem is, when i use a LOV selected value the post query trigger is not firing in the second block and i cannot understand why. The relationship is set up correctly as records are correctly displayed when i navigate through them using the default keys on the form. My code to open the LOV is as follows:

DECLARE
    SUCCESS BOOLEAN;
    BEGIN
    do_key('clear_form');
    SUCCESS := SHOW_LOV('STUDENT_LIST');
    set_item_property('registration.netid', property_true);
    END;
Solution

  • you have to call execute_query to make post_query fired.