fill object type with table data

I have following table:

 Name                                                  Null?    Typ
 ----------------------------------------------------- -------- ------------

 IX_AB_KA_ID                                           NOT NULL NUMBER(10)
 IX_AB_KA_STARTID                                      NOT NULL NUMBER(10)
 IX_AB_KA_ENDID                                        NOT NULL NUMBER(10)

 IX_AB_KA_BEWERTUNG_VOR                                NOT NULL NUMBER(15,6)
 IX_AB_KA_BEWERTUNG_ZURUECK                            NOT NULL NUMBER(15,6)
 IX_AB_KA_LAENGE                                       NOT NULL NUMBER(10,6)
 IX_AB_KA_RICHTUNG                                              NUMBER
 IX_AB_KA_IDX                                          NOT NULL NUMBER(10)
 IX_AB_KA_LEV_START                                             NUMBER(2)
 IX_AB_KA_LEV_END                                               NUMBER(2)
 IX_AB_KA_MAPKEY                                       NOT NULL VARCHAR2(30)
 IX_AB_KA_ROADCLASS                                             NUMBER(3)

and following object:

 Name                                                  Null?    Typ
 ----------------------------------------------------- -------- ------------

 IX_AB_KA_ID                                           NOT NULL NUMBER(10)
 IX_AB_KA_STARTID                                      NOT NULL NUMBER(10)
 IX_AB_KA_ENDID                                        NOT NULL NUMBER(10)

 IX_AB_KA_BEWERTUNG_VOR                                NOT NULL NUMBER(15,6)
 IX_AB_KA_BEWERTUNG_ZURUECK                            NOT NULL NUMBER(15,6)
 IX_AB_KA_LAENGE                                       NOT NULL NUMBER(10,6)
 IX_AB_KA_RICHTUNG                                              NUMBER
 IX_AB_KA_IDX                                          NOT NULL NUMBER(10)
 IX_AB_KA_LEV_START                                             NUMBER(2)
 IX_AB_KA_LEV_END                                               NUMBER(2)
 IX_AB_KA_MAPKEY                                       NOT NULL VARCHAR2(30)
 IX_AB_KA_ROADCLASS                                             NUMBER(3)

i created a nested table type with this object:

how can i fill this table with data of my database table??

thanks for helping

Andi Schwaiger Received on Tue Feb 22 2000 - 22:50:01 CET