My Oracle Support Banner

FAQ: Oracle R Enterprise and External Procedures (Doc ID 2313299.1)

Last updated on OCTOBER 19, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document provides information about how to troubleshoot Oracle Database external procedure for use with Oracle R Enterprise.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1. How do I configure extproc for use with Oracle R Enterprise?
 2. When I try to use embedded R execution in Oracle R Enterprise, I receive the error: ORA-28575: unable to open RPC connection to external procedure agent.
 a. Create two C file test.c and test2.c with the following:
 b. Create a shared library:
 c. Copy Shared libraries to $ORACLE_HOME/lib:
 d. Ensure libtest2.so can be loaded by test.so:
 e. Grant dba privileges to your database user:
 f. Create an external procedure library called test
 g. Create function negative_it to run in the external procedure
 h. If extproc with callbacks are working properly on the database server, the following value will be returned from the function
 3. How can I restrict external procedure calls to use Oracle R Enterprise only?
 4. I've configured Oracle Wallet, and when I attempt to connect to Oracle Database my session hangs or returns an extproc error.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.