I have a problem. I'm using objects/types in an inheritance-hierarchi. Like this:

Top-Level: PERSON
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?