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.