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!

Cannot create varray

jerry44May 24 2015 — edited May 25 2015

I've tried to create varray that uses rowtype based on table from HR schema on schema system using SQL Developer:

create or replace type arr_countries is varray(5) of hr.countries%rowtype;

Result I was returned:

Error(1,39): PLS-00329: schema-level type has illegal reference to HR.COUNTRIES

Is it impossible to do it the way I did, or there is problem with priviledges?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2015

Added on May 24 2015

#error, #schema

5 comments

1,040 views