PL/SQL (MOSC)

MOSC Banner

Assigning Values to Nested Varrays

edited Apr 4, 2014 12:00PM in PL/SQL (MOSC) 4 commentsAnswered

I'm new to this so some help would be greatly appreciated. I have a nested Varray datatype that has another Varray type in the object.  I can seem to read values from the database in a bulk insert into just the main object annot the sub array.  fro example:

SQL> desc USER_ACCT_ROLE_ARRAY

USER_ACCT_ROLE_ARRAY VARRAY(500) OF USER_ACCT_ROLE_TYPE

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

USER_ACCOUNT_ROLE_ID                               NUMBER

USER_ACCOUNT_ID                                    NUMBER

ROLE_ID                                            NUMBER

ACTIVE                                             NUMBER(1)

CREATED_BY                                         VARCHAR2(20)

CREATED_DATE                                       DATE

LAST_MOD_BY                                        VARCHAR2(20)

LAST_MOD_DATE                                      DATE

REGISTRATION_TYPE                                  VARCHAR2(10)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center