I have a problem. I'm using objects/types in an inheritance-hierarchi. Like this:
Under Person: CLUBMEMBER and AUTHOR
Under Clubmember: EMPLOYEE and MEMBER
The problem is that EMPLOYEE and MEMBER has to be overlapping; an EMPLOYEE is also a MEMBER. This is not possible in an Oracle-database when using objects. It has to be inserted as either an EMPLOYEE or a MEMBER.
Anybody got any good ideas of how to solve this type of problem?