Skip to content
Advertisement

‘SET’ must be a type

I created the following types :

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

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

Advertisement

Answer

If you want an array of phone numbers for each person, define the phone number type as a nested table:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement