Oracle Forms for User Response in Alert

First Define the Alert in Form:


Query: Alert can be used in Oracle Forms for user response.
   
     DECLARE
       al_id Alert;
       al_button NUMBER;
    BEGIN
         al_id := Find_Alert('');
      
         al_button := Show_Alert(al_id);
      
         IF al_button = ALERT_BUTTON1 THEN    -- Here Alert_button1 value is OK
                   <<    Condition >>
          null;
         ELSE
                   <<   Condition  >>
           RAISE Form_trigger_Failure;
         END IF;
    END;








No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...