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

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.