Alert in Oracle Forms for User Response

 Here is how a 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 -- Alert_button1 value is OK
          --<<--Your Condition-->>
          null;
         ELSE
           --<<--Your 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 ...