ORA-20000: RQuery error output data.frame does not match output specification

(Doc ID 2330832.1)

Last updated on JANUARY 03, 2018

Applies to:

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

Symptoms

Error reported during following steps executed


begin
sys.rqScriptDrop( 'SID' );
end;

begin
sys.rqScriptCreate( 'SID',' function(){ return( data.frame(ORACLE_SID = Sys.getenv( "ORACLE_SID" ) ) ); } ' );
end;

10:43:01 OFSAUATS@OFSAUATS> select * from table ( rqEval( NULL, 'select ''1234567890123456789123456789'' as ORACLE_SID from dual', 'SID'));
select * from table ( rqEval( NULL, 'select ''1234567890123456789123456789'' as ORACLE_SID from dual', 'SID'))
*
ERROR at line 1:
ORA-20000: RQuery error
output data.frame does not match output specification
ORA-06512: at "RQSYS.RQEVALIMPL", line 104
ORA-06512: at "RQSYS.RQEVALIMPL", line 101

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