The SQL API for Embedded R Execution with Autonomous AI Database provides SQL interfaces for setting authorization tokens, managing access control list (ACL) privileges, executing R scripts, and synchronously and asynchronously running jobs.

• 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 R Execution Functions (Autonomous AI Database)
  The SQL API for Embedded R Execution with Autonomous AI Database functions are described in the following topics.
• Asynchronous Jobs
  When a function is run asynchronously, it's run as a job which can be tracked by using the rqJobStatus and rqJobResult functions.
• Special Control Arguments
  Use the PAR_LST parameter to specify special control arguments and additional arguments to be passed into the R script.
• Output Formats
  The OUT_FMT parameter controls the format of output returned by the table functions rqEval2, rqGroupEval2, rqIndexEval2, rqRowEval2, rqTableEval2, and rqJobResult.