10.6 SQL API for Embedded Python Execution with Autonomous Database
The SQL API for Embedded Python Execution with Autonomous Database provides SQL interfaces for setting authorization tokens, managing access control list (ACL) privileges, executing Python scripts, and synchronously and asynchronously running jobs.
The following topics describe the SQL API interfaces for Embedded Python Execution.
Topics:
- Access and Authorization Procedures and Functions
Use the network access control lists (ACL) API to control access by users to external network services and resources from the database. Use the token store API to persist the authorization token issued by a cloud host so it can be used with subsequent SQL calls. - Embedded Python Execution Functions (Autonomous Database)
The SQL API for Embedded Python Execution with Autonomous Database functions are described in the following topics. - Asynchronous Jobs (Autonomous Database)
When a function is run asynchronously, it's run as a job which can be tracked by using thepyqJobStatus
andpyqJobResult
functions. - Special Control Arguments (Autonomous Database)
Use thePAR_LST
parameter to specify special control arguments and additional arguments to be passed into the Python script. - Output Formats (Autonomous Database)
TheOUT_FMT
parameter controls the format of output returned by the table functionspyqEval
,pyqGroupEval
,pyqIndexEval
,pyqRowEval
,pyqTableEval
, and pyqJobResult.
Parent topic: Embedded Python Execution