ORA-20000: RQuery Error From Oracle R (Doc ID 1996079.1)

Last updated on MAY 06, 2015

Applies to:

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

Symptoms

1. --run this to add script to library:
begin
sys.rqScriptCreate('ForecastTest',
'function(dsIn) {
library(forecast)
dsReturn <- data.frame(TEST=character(0))
dsReturn
}
');
end;
/

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',
'ForecastTest')
) x
;

error:
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.
 

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