IF UPPER (lc_phase ) = 'COMPLETED' AND UPPER (lc_status ) = 'ERROR' THENĭbms_output. WHEN UPPER (lc_phase ) = 'COMPLETED' OR UPPER (lc_status ) IN ( 'CANCELLED', 'ERROR', 'TERMINATED' ) , INTERVAL => 5 -interval Number of seconds to wait between checks ,max_wait => 60 -Maximum number of seconds to wait for the request completion - out arguments ,phase => lc_phase wait_for_request (request_id => lv_request_id To make process execution to wait for 1st program to complete -įnd_concurrent. put_line ( 'The Program PROGRAM_1 submitted successfully – Request id :' || lv_request_id ) put_line ( 'Request Not Submitted due to "' || fnd_message. DECLARE - += - | Purpose : How to make a Concurrent Program WAIT till completion another Concurrent Program execution? - | Author : Shailender Thallam - +=.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |