Am I correct that rqEval cannot accept non-numeric data frames in the 'SELECT ..'? I tried this
begin
sys.rqScriptCreate('Test',
'function() {
library(ROracle)
drv <- dbDriver("Oracle")
con <- dbConnect(drv, username = "rquser", password="password", dbname = "ORCLPDB", prefetch = FALSE,external_credentials = FALSE)
Industry <- "Text"
data.frame(Industry = Industry)
}',
v_overwrite => TRUE);
end;
/
select * from table(rqEval(NULL,'select 1 "Industry" from dual', 'Test'));
and got the error
ORA-20000: RQuery error
output data.frame contains unsupported types
When "Text" is changed to a number like
Industry <- 25
the script runs fine with 25 for the Industry column.
If rqEval cannot accept non-numerics, what alternative is there to insert non-numeric results into an Oracle table?