Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ORE sys.rqScriptCreate Procedure not availlable in 12C database

Question
1
Views
0
Comments

I have installed Oracle 12C database and pdb, cdb configured correctly. I can see RQUSER all ORE related tables under that user. But unable to see the procedure "rqScriptCreate" with sys user. As a result I am unable to run any ORE script as below and getting error -

begin

sys.rqScriptCreate('ORE_Example1',

'function(){

res <- 1:10

plot( 1:100, rnorm(100), pch = 21,

bg = "red", cex = 2 )

res

}');

end;

Error report -

ORA-06550: line 2, column 1:

PLS-00201: identifier 'SYS.RQSCRIPTCREATE' must be declared

ORA-06550: line 2, column 1:

PL/SQL: Statement ignored

06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

I can not see any function also under sys or RQUSER -

rqTableEval()

  • rqEval()
  • rqRowEval()
  • rqGroupEval()

However when I am checking $ORACLE_HOME/R/  I can see Library, migration, ORE_1_2 directory. And under library I can see all R library which indicates ORE already installed with database. So all "rqScriptCreat" procedure and other functions must be exist as I know from 11G databse. In 12C I can not see the same as a reason my ORE codes are not running. Can you please help how can I get all ORE related procedures in 12C data database, if there is any change on 12C database.