11.7.3 Asynchronous Jobs (Autonomous Database)
When a function is run asynchronously, it's run as a job which can be
tracked by using the pyqJobStatus
and pyqJobResult
functions.
Topics:
Asynchronous Jobs is described in the following topics:
- oml_async_flag Argument
The special control argumentoml_async_flag
determines if a job is run synchronously or asynchronously. The default value is false. - pyqJobStatus Function
Use thepyqJobStatus
function to look up the status of an asynchronous job. If the job is pending, it returnsjob is still running
. If the job is completed, the function returns a URL. - pyqJobResult Function
Use thepyqJobResult
function to return the job result. - Asynchronous Job Example
The following examples shows how to submit asynchronous jobs with non-XML output and with XML output.