ORA-00904 error while running ore.doEval

(Doc ID 2391380.1)

Last updated on MAY 03, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 Installation of Oracle R Distribution and Oracle R Enterprise completed successfully

> ore.connect(user="username", sid="sid_name", host="host_name", password="pwd",port=<port_number>, all=TRUE)
> ore.is.connected()
[1] TRUE
>
> ## List the available database tables
> ore.ls()
[1] "T1"
>
> ## Push an R dataframe to a database table
> CARS <- ore.push(cars)
> head(CARS)
speed dist
1 4 2
2 4 10
3 7 4
4 7 22
5 8 16
6 9 10
>
> ## Run embedded R
> ore.doEval(function(){library(ORE)})
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
ORA-00904: "Version": invalid identifier

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms