Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL: ORA-22905: cannot access rows from a non-nested table item

3631507Oct 31 2019 — edited Nov 12 2019

I tried to create the following trigger:

create or replace trigger rating

after insert on loanapplication

begin

  select * from table(rqEval(NULL,'select 1 dum from dual', 'IRS'));

end;

and got the error PL/SQL: ORA-22905: cannot access rows from a non-nested table item

IRS is a Oracle R function and dum is just a dummy data frame. I posted this in the R Technologies room but haven't gotten a response.  I've also web-searched nested tables but can't find a solution.

Any help is appreciated.
This post has been answered by padders on Nov 2 2019
Jump to Answer

Comments

Hi Penny,

This is a known issue.  Please connect with me directly for the fix.

Thank you,

Sherry

Hasnur Ramadhan

Hi Sherry,

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

---

How to connect with you directly to get the fix?

Currently I am doing a POC using ORE Oracle 19c for a prospective customer.

TIA.

Hasnur R.

Hasnur Ramadhan

Solved with Oracle R Distribution 3.6.1, and re-download OML for R library 1.5.1 (the latest one, dated August 24, 2020).

1 person found this helpful
Sherry Lamonica-Oracle

Thank you for the update, Hasnur. Oracle R Distribution 3.6.1 is now available.  Refer to this blog post for details and a pointer to installation instructions with Oracle Machine Learning for R 1.5.1, which contains the fix for the OREdm bug discussed in this thread.

Sherry

1 person found this helpful
1 - 4

Post Details

Added on Oct 31 2019
#trigger
37 comments
23,586 views