creating a table with an object

first i have create a type:
TYPE VARCHAR2_TABLE AS TABLE OF VARCHAR2(4000) then i make an object containing this:
CREATE OR REPLACE TYPE TYPE_EMAIL_OBJECT AS OBJECT ( HOSTNAME VARCHAR2_TABLE,
PORT NUMBER,
SENDER_EMAIL_ADDRESS VARCHAR2(4000),
EMAIL_TEXT VARCHAR2_TABLE) this works.

Now i want to make a table containing this object: CREATE TABLE EMAIL_test
(send VARCHAR2(1),

email TYPE_EMAIL_OBJECT)

at this point i will get an error:

ORA-22913: must specify table name for nested table column or attribute

What must i do to make it working?

Sorry for the bad english and the formatting.

Greetings

Micha Received on Thu Jun 14 2007 - 02:16:48 CDT