Oracle PL/SQL/Object Oriented Database/final

Override a final member function

   <source lang="sql">

SQL> create or replace

 2    type super_type as object(
 3      n number,
 4      final member procedure cannot_override
 5    )
 6    not final
 7    /

Type created. SQL> SQL> create or replace

 2    type sub_type
 3    under super_type(
 4      overriding member procedure cannot_override
 5    )
 6    /

Warning: Type created with compilation errors. SQL> SQL> show error Errors for TYPE SUB_TYPE:

LINE/COL ERROR

---

-----------------------------------------------------------------

0/0 PL/SQL: Compilation unit analysis terminated 3/23 PLS-00637: FINAL method cannot be overriden or hidden SQL> drop type super_type;

drop type super_type

ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents

SQL> SQL>

</source>