9.6 SQL API for Embedded R Execution with Autonomous Database
The SQL API for Embedded R Execution with Autonomous Database provides SQL interfaces for setting authorization tokens, managing access control list (ACL) privileges, executing R scripts, and synchronously and asynchronously running jobs.
The following topics describe the SQL API.
- 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 Database)
The SQL API for Embedded R Execution with Autonomous 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 therqJobStatus
andrqJobResult
functions. - Special Control Arguments
Use thePAR_LST
parameter to specify special control arguments and additional arguments to be passed into the R script. - Output Formats
TheOUT_FMT
parameter controls the format of output returned by the table functionsrqEval2
,rqGroupEval2
,rqIndexEval2
,rqRowEval2
,rqTableEval2
, and rqJobResult.
Parent topic: Embedded R Execution