This discussion is archived
8 Replies Latest reply: Feb 8, 2013 1:09 AM by 494921 RSS

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

twinklin_girl Explorer
Currently Being Moderated
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 :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points