REQUEST_STATUS

Description

Function used to retrieve the status of the Concurrent Manager request.

Parameters

• 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.

Requirements

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.