Are Oracle nested tables supported in PD 16.5 ?

[Former Member]

Hi,

I'm trying to model a new table with a nested table as one of the columns.

I am using PD16.5 SP02, with RDBMS version Oracle 10gR2.

I cannot find how this can be done...

Can anyone help me?

Thanks,

Yoni.

[arnaud_laurent · Accepted solution]

Hello,

In PD 6.5 SP05, I do the following:
- edit the table

- click the Physical options table
- add <column_properties> \ <property> \ <nexted_table_col_properties> \ nested table (column_value)
- click OK

HTH,

Arnaud

[Former Member · Accepted solution]

Hi Arnaud,

Thanks for you suggestion!
I did as you suggested, and was able to generate the NESTED TABLE clause of the CREATE TABLE below:

create table T_NESTED_TBL  (

   CLMN_1               CHAR(10)

)

nested table CLMN_1 store as CLMN_1_tab;

However, I am still facing a problem, since the datatype of the column CLMN_1 is CHAR(10) (displayed in column properties a "undefined" )...

How can I:

1. Create a database type to use as the column datatype.

2. be able to choose this type from a list as the datatype for the column or enter it manually

For example:

CREATE OR REPLACE TYPE my_tab_t AS TABLE OF VARCHAR2(30);

Then CREATE TABLE will be:

create table T_NESTED_TBL  (

   CLMN_1               my_tab_t

)

nested table CLMN_1 store as CLMN_1_tab;

Thanks again for your help!

Yoni.

[arnaud_laurent · Accepted solution]

Hello,

Select Model > Abstract Data Types to create my_tab_t.
Then choose my_tab_t to select the data type in the Column property sheet.

HTH

[Former Member · Accepted solution]

Thanks a lot!