INSERTing into O-R Schema

[wwwian]

Using 8.1.7 and need to insert into the following schema (example)

CREATE TYPE y_type AS OBJECT
(
z VARCHAR2(1)
);
/

CREATE TYPE x_type AS OBJECT
(
y y_type
);
/

CREATE TABLE x
(
x x_type
);
/

Need to insert a value into z !

Any ideas ??????

 

[wwwian]

Solution is

INSERT INTO x VALUES (x_type(y_type('Z'))