ORA-20000: RQuery Error From Oracle R

(Doc ID 1996079.1)

Last updated on JULY 18, 2018

Applies to:

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


1. --run this to add script to library:
'function(dsIn) {
dsReturn <- data.frame(TEST=character(0))

2. --run this query and it runs the first time, but 2nd execution it generates the following error:
select * from table( rqTableEval(cursor(
select 1 test from dual
, null,
'select ''c'' test from dual',
) x

ORA-20000: RQuery error
Error in (function () :
unused arguments (width = 480, bg = "white", type = "raster")
ORA-06512: at "RQSYS.RQTABLEEVALIMPL", line 112
ORA-06512: at "RQSYS.RQTABLEEVALIMPL", line 109
20000. 00000 - "%s"
*Cause: The stored procedure 'raise_application_error'
was called which causes this error to be generated.
*Action: Correct the problem as described in the error message or contact
the application administrator or DBA for more information.


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