Hello All.
I'm install R Enterprise in my ora 11 base. And try execute code.
From RStudio I run this:
"
## Is the ORE client connected to the ORE server?
## The output of this command should be TRUE.
ore.is.connected() - it's work
## List the available database tables
ore.ls() - It's work too
## Push an R dataframe to a database table
CARS <- ore.push(cars) -OK
head(CARS) -OK
## Run embedded R
ore.doEval(function() { 123 }) - It's ERROR
"
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to load DLL
ORA-06512: at "RQSYS.RQEVALIMPL", line 17
ORA-06512: at "RQSYS.RQEVALIMPL", line 14
ORA-06512: at line 4
More, I run this from SQL Developer:
"
BEGIN
sys.rqScriptCreate('myRandomRedDots2',
'function(divisor = 100, numDots = 100) {
id <- 1:10
plot(1:numDots, rnorm(numDots), pch = 21, bg = "red", cex = 2 )
data.frame(id = id, val = id / divisor)
}');
END;
/
"
It's correct.
But it's ERROR:
"SELECT *
FROM table(rqEval(NULL, 'SELECT 1 id, 1 val FROM dual', 'myRandomRedDots2'));
"
ORA-06520: PL/SQL: Ошибка загрузки внешней библиотеки
ORA-06522: Unable to load DLL
ORA-06512: на "RQSYS.RQEVALIMPL", line 17
ORA-06512: на "RQSYS.RQEVALIMPL", line 14
ORA-06512: на line 4
06520. 00000 - "PL/SQL: Error loading external library"
*Cause: An error was detected by PL/SQL trying to load the external
library dynamically.
*Action: Check the stacked error (if any) for more details.
Please HELP ME. Where solution?