ORA-20000: RQuery Internal Error [rqetXMLOutput, 3, 24811, 0] (Doc ID 2279871.1)

Last updated on JUNE 30, 2017

Applies to:

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

Symptoms

You execute in R the following 3 instructions:


ore.doEval(FUN.NAME = "/DS/17092/U0192057/xml_sql_directo2/20170202_v12", ore.connect=TRUE)
ore.doEval(FUN.NAME = "/DS/17092/U0192057/xml_sql_directo2/20170202_v10", ore.connect=TRUE)

And in both containing ñ this is displayed correctly. The non-special function also works correctly.

If in SQL you execute:
select * from "U0192057"."Log_Data"

You see that the special character of the table has been correctly registered.
Then you  run the scripts from SQL Dev:

select value
from table (rqEval(cursor(Select 1 "ore.connect" FROM dual),
'XML', '/DS/17092/U0192057/xml_sql_directo2/20170202_v12'))

select value
from table (rqEval(cursor(Select 1 "ore.connect" FROM dual),
'XML', '/DS/17092/U0192057/xml_sql_directo2/20170202_v10'))



You see that in the second select, which contains the ñ, you  always get the following error:

ORA-20000: RQuery internal error [rqetXMLOutput, 3, 24811, 0]
ORA-06512: en "RQSYS.RQTABLEEVALIMPL", línea 104
ORA-06512: en "RQSYS.RQTABLEEVALIMPL", línea 101
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.
 

 Following generic test performed from SQL Developer
 ---------------------------------------------------
 Select 'ñ' from dual or  select from table
 
 Both works and shows ñ.
 
 Native ORA error raised while querying from R packages
 
ORA-20000: RQuery internal error [rqetXMLOutput, 3, 24811, 0]
ORA-06512: en "RQSYS.RQTABLEEVALIMPL", línea 104
ORA-06512: en "RQSYS.RQTABLEEVALIMPL", línea 101
20000. 00000 - "%s"

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