12.7.3.3 pyqJobResult Function
Use the pyqJobResult
function to return the job
result.
Syntax
FUNCTION PYQSYS.pyqJobResult(
job_id VARCHAR2,
out_fmt VARCHAR2 DEFAULT 'JSON'
)
RETURN SYS.AnyDataSet
Parameters
Parameter | Description |
---|---|
job_id |
The ID of the asynchronous job. |
out_fmt |
The format of the job result. It can be one of the following:
|
Example
The following example shows a pyqJobResult
call and its
output.
SQL> select * from pyqJobResult(
job_id => '<job id>',
out_fmt => '{"NAME":"varchar2(7)","SCORE":"number","FINALGRADE":"number","DIFF":"number"}'
);
NAME SCORE FINALGRADE DIFF
---------- ---------- ---------- ----------
Abbott 90 87 3
Branford 92 97 -5
Crandell 81 71 10
Dennison 85 72 13
Edgar 89 80 9
Faust 78 73 5
Greeley 82 91 -9
Hart 84 80 4
Isley 88 86 2
Jasper 91 83 8
10 rows selected.
Parent topic: Asynchronous Jobs (Autonomous Database)