1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

'SET' must be a type

Discussão em 'Outras Linguagens' iniciado por Stack, Janeiro 11, 2021.

  1. Stack

    Stack Membro Participativo

    I created the following types :

    CREATE TYPE Adress AS Object (Street varchar2(50), PostalC number, Ville varchar2(50));
    CREATE TYPE PhoneNumber;


    A person can have a set of PhoneNumbers, when I try to create the Type Person :

    CREATE TYPE Person AS Object (FirstName varchar2(50), LastName varchar2(50), Adr Adress, Mobile SET(PhoneNumber));


    I get the following error :


    Errors: TYPE PERSON Line/Col: 0/0 PL/SQL: Compilation unit analysis terminated Line/Col: 1/90 PLS-00488: 'SET' must be a type

    Continue reading...

Compartilhe esta Página