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!

Assigning values to a table of objects

StephenOct 18 2005 — edited Oct 19 2005

Hi ,

I need some help in getting values inside a tbl of objects..I have a procedure with an OUT parameter xxus.xx_user_table_obj ( which is table of obj of xx_user_obj)

The structure of xx_user_obj is

TYPE XX_USER_OBJ AS A OBJECT (
USER_ NAME VARCHAR2
ENTRY_ LEVEL NUMBER
ACC_ID VARCHAR2
USER _SHORT VARCHAR2
PRIMARY_CONTACT VARCHAR2
COMM_ACCESS VARCHAR2
FIRST_NAME VARCHAR2
LAST_NAME VARCHAR2
EMAIL VARCHAR2
QUALIFICATION VARCHAR2
METHOD_CODE VARCHAR2
I_ACCESS VARCHAR2
S_ACCESS VARCHAR2
)

My Question is that I have an array which holds 13 values and I will have to assign those 13 valuesto the table of object..

Any sample code or solutions to solve this would be a great help to me.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2005

Added on Oct 18 2005

3 comments

445 views