10.4.1.3 Connect to Oracle Machine Learning for R in Embedded R Execution

To establish a connection to OML4R on the Oracle Database server during the Embedded R Execution, you can specify the control argument ore.connect in the parameters list.

Doing so establishes a connection using the credentials of the user who invoked the embedded R function. It also automatically loads the ORE package. Establishing an OML4R connection is required to save objects in an OML4R R object datastore or to load objects from a datastore. It also allows you to explicitly use the OML4R transparency layer.

See Also:

Optional and Control Arguments for information on other control arguments

Example 10-15 Connect to OML4R in Embedded R execution

This example establishes a connection to OML4R on the Oracle Database server during the Embedded R Execution.

select VALUE from table(rqEval2('{"ore.connect":1}', 'XML', '<script name>'));