Forum Stats

  • 3,769,410 Users
  • 2,252,962 Discussions
  • 7,875,023 Comments

Discussions

Error: ORD 3.6.1, OML4R 1.5.1 and Oracle DB 19c

Hasnur Ramadhan
Hasnur Ramadhan Member Posts: 30 Bronze Badge

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0

MS Windows 10 Pro

Connection is to a Pluggable database.

Oracle Distribution of R version 3.6.1 (2018-03-15)

OML4R 1.5.1 packages (R-3.6.1)

I have got error for:

----

ore.doEval(function(){123})

Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  :

  ORA-06520: PL/SQL: Error loading external library

ORA-06512: at line 11

ORA-06512: at "RQSYS.RQEVALIMPL", line 17

ORA-06512: at "RQSYS.RQEVALIMPL", line 14

ORA-06512: at line 6

------

fit <- ore.neural('default10yr ~ LTI + age', data = trainData, hiddenSizes = c(5L), , activations = c("sigmoid", "linear"))

Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  :

  ORA-06520: PL/SQL: Error loading external library

ORA-06512: at line 11

ORA-06512: at "RQSYS.RQEVALIMPL", line 17

ORA-06512: at "RQSYS.RQEVALIMPL", line 14

ORA-06512: at line 6

----

oreFit <- ore.lm(Fare ~ ., data = airfare_odf)

Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  :

  ORA-06520: PL/SQL: Error loading external library

ORA-06512: at line 11

ORA-06512: at "RQSYS.RQEVALIMPL", line 17

ORA-06512: at "RQSYS.RQEVALIMPL", line 14

ORA-06512: at line 6

---

BUT there is no error for some other ORE algorithms:

-----

km.iris<- ore.odmKMeans(~., a,num.centers=3, auto.data.prep=FALSE)

-----

ar.mod <-ore.odmAssocRules(~., ore.assoc_df, case.id.column= "TRANS_ID", item.id.column= "PRODUCT_ID", min.support= 0.5, min.confidence= 0.7, max.rule.length = 3)

-----

Thanks.

Hasnur Ramadhan

Answers