PL/SQL InstanceOf Operator?
I have three objects, two of which are descendants of the same supertype. I then declare a collection to contain the supertype. Within PL/SQL I can create instances of the subtypes and place them in the collection, but how can I programmatically determine the type when I go to get the object back out of the collecton? I found an IS OF clause in the documentation, but this appears to be a SQL operator. I get an error if I try to do something like "IF v_obj IS OF some_obj_type THEN ..." Is there something like Java's InstanceOf operator to test for a class type at runtime?
I am using 9.0.1. Thanks for any help.