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

    plsql how to determine what the instance of an object is

    phil_xxx
      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
      begin
      -- 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;

      end;
      /

      thanks in advance