basic objects: ORA-00932 when INSERT object type data

Question

Part of my homework. I know this is quite basic, but it is not so intuitive for me. I create this:

    CREATE TYPE Address_typ AS OBJECT (
      AddressNo  NUMBER,
      Street    VARCHAR2(64),
      PostCode  VARCHAR2(9),
      Town      VARCHAR2(64)
      );
    /

    CREATE TYPE Customer_typ AS OBJECT (
      CustNo         NUMBER,
      customer_name  VARCHAR2(64),
      VAT_NO         VARCHAR2(18),
      Address_ref    REF Address_typ
      );
    /

CREATE TABLE Address_table OF Address_typ;

CREATE TABLE Customer_table OF Customer_typ
(Address_ref SCOPE IS Address_table);

this insert works:

INSERT INTO Address_table VALUES(Address_typ(1,'Strumykowa 5','65-001', 'Zielona Góra'));

and one below is not (with empty Address_table):

INSERT INTO Customer_table VALUES(Customer_Typ(1,'PPUH ZZPD', '12345678901', Address_typ(1,'Strumykowa 5','65-001', 'Zielona Góra')));

How should I insert correctly into Customer_table

should the Customer_typ be relative?... I guess not necessary. — mallorn
– mallorn, Commented Jan 27, 2016 at 21:14

Piotr Siekierski · Accepted Answer · 2016-01-27 22:21:28Z

2

This way will work:

INSERT INTO Customer_table
VALUES(Customer_Typ(1,'PPUH ZZPD', '12345678901', (select ref(a) from address_table a where a.AddressNo = 1)));

answered Jan 27, 2016 at 22:21

Piotr Siekierski

4942 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mallorn Over a year ago

Thanks, strange that I didn't figure it out myself.

Collectives™ on Stack Overflow

basic objects: ORA-00932 when INSERT object type data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related