8 Replies Latest reply: Feb 8, 2013 3:09 AM by 494921 RSS

    How to populate items from two data blocks when clicking execute query?

    twinklin_girl
      How to populate items from two data blocks when clicking execute query in the menu? So far , only items from my first block gets populated .
      I need to enter query in the second block , then click on "execute query" again to populate the items .


      At form level ,my execute query trigger contains the following :

      DECLARE
           Fail EXCEPTION;
           alert_title varchar2(100) := null; -- 10g
           p_button_choice number := 0; -- 10g : for Stop_Alert, Caution_Alert & Note_Alert
      Begin
           If :system.block_status NOT IN ('NEW', 'QUERY') THEN
                begin
                alert_title := 'Execute Query is not allowed in this mode - COMMIT changes or Clear Form to cancel';
                Alerts.Stop_Alert (alert_title, p_button_choice);
                raise form_trigger_failure;
           end;
           Else
                execute_query;
           End if;
      End;

      Please help, thanks :)