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

• Access and Authorization Procedures and Functions
• Embedded Python Execution Functions (Autonomous Database)
• oml_async_flag Argument
• Special Control Arguments (Autonomous Database)
• Output Formats (Autonomous Database)

• 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 the pyqJobStatus and pyqJobResult functions.
• Special Control Arguments (Autonomous Database)
  Use the PAR_LST parameter to specify special control arguments and additional arguments to be passed into the Python script.
• Output Formats (Autonomous Database)
  The OUT_FMT parameter controls the format of output returned by the table functions pyqEval, pyqGroupEval, pyqIndexEval, pyqRowEval, pyqTableEval, and pyqJobResult.