Skip to Main Content

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

Srn87-Oracle

Hello,

    I am assuming you are trying to find out the costs of running oracle database on an AWS EC2 instance.

As far as i know,oracle database edition is free to use as long as it is used for non-production/non-commercial usages etc.Oracle licensing is not a straightforward topic and i doubt there is very little information in public domain on this.The licensing can be done based on many aspects,such as named users connecting to the db or based on db processors itself.Customer generally  has to work with Oracle sales to figure out a licensing plan that best suits their requirements.

Hence,I would suggest you to get in touch with your oracle sales representative who can give you the exact figures and conditions in terms of costing.

By the way,I think,running oracle on OCI could be far cheaper than running oracle on AWS EC2.

1 - 1

Post Details

Added on Oct 31 2019
37 comments
23,823 views