Is there anyway to declare a TYPE without a Property in Oracle 10gR2

Question

I want to create a base object that has only methods. The object would be QUEUABLE_OBJECT_TYPE and it will have an ENQUEUE method(s). The Payload of these messages (properties) would be added by subtyping this object.

I get an error that makes it sound like you cannot.

PLS-00589: no attributes found in object type "QUEUABLE_OBJECT_TYPE"

Does anyone know a way around this error? Or is it possible in the subtypes to hide this property of the supertype?

Either would be an acceptable answer.

Answer 1

Everything I've read suggests it is not possible to create a type without any attributes. Nor is it possible to hide a dummy attribute in a subtype. You may simply have to have an attribute in the master type, and utilise it - e.g. by making it identify the version of the type.

Answer 2

Oracle does provide some generic types, see documentation for details