Function used to retrieve the status of the Concurrent Manager request.
INp_request_id IN NUMBER
Request Id for the concurrent Manager; basically, the return value from REQUEST.
INp_interval_sec IN NUMBER
The interval in seconds for the program to query for the result of a Concurrent Manager request.
INp_maximum_sec IN NUMBER
The maximum allowed interval (in seconds) for the program to time out. This parameter must have a non-zero value.
OUTp_detailed_status OUT VARCHAR2
Output parameter having the detailed description of the concurrent request.
In order for Request_Status to correctly retrieve the Concurrent Manager request, you must call commit after the Request stored procedure call; otherwise, Request_Status always returns Pending status after a time-out.