4 Replies Latest reply on May 11, 2006 7:01 PM by ABB

    plsql how to determine what the instance of an object is

      In my procedure I want to know if I have been passed the supertype of a sub type ie :

      create type super_type as object
      (id number(10) )

      create type sub_a under super_type
      (a varchar2(10))

      create procedure p_x(p_obj super_type) is
      -- something like :
      if p_obj is of type super_type then
      -- do something
      elsif p_obj is of type sub_a then
      -- something
      end if;


      thanks in advance