0 Replies Latest reply on Mar 11, 2018 5:56 PM by David from Austria

    Missing "Navigate to Type Body" icons using reserved word FORCE

    David from Austria

      I'm missing navigation icons using "FORCE" reserved word when creating a type. MIssing in Spec and Body.

       

      Without reserved word FORCE

      sqldeveoper type nav icons.jpg

      With reserved word FORCE

      sqldeveoper type nav icons missing.jpg

       

       

      CREATE OR REPLACE TYPE t_dummy2

      FORCE /* causes disappearance of "Navigate to Type Body" icons */

      AS OBJECT

      (

        its_a_object VARCHAR2(30)

      , its_a_date   DATE

      , its_a_day    VARCHAR2(15)

      , CONSTRUCTOR FUNCTION t_dummy2( p_its_a_object IN VARCHAR2

                                     , p_its_a_date   IN DATE

                                     , p_its_a_day    IN VARCHAR2

                                     ) RETURN SELF AS RESULT

      , member function do_something RETURN NUMBER                            

      );

      /

       

      CREATE OR REPLACE TYPE BODY T_DUMMY2 AS

       

      CONSTRUCTOR FUNCTION t_dummy2( p_its_a_object IN VARCHAR2

                                   , p_its_a_date   IN DATE

                                   , p_its_a_day    IN VARCHAR2

                                     ) RETURN SELF AS RESULT

      IS                            

        BEGIN

          its_a_object := p_its_a_object;

          its_a_date   := p_its_a_date;

          its_a_day    := p_its_a_day;

        END;

        --

        MEMBER FUNCTION do_something RETURN NUMBER       

        is

        BEGIN

          RETURN 0;

        END;

      END;

      /