NOT FINAL : FINAL « Object Oriented « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Object Oriented
3. FINAL

SQL> CREATE TYPE myError AS OBJECT (
  2     name VARCHAR2(100),
  3     code INTEGER,
  4     description VARCHAR2(4000),
  5     help_text VARCHAR2(4000),
  6     recommendation VARCHAR2(4000),
  7     error_stack CLOB,
  8     call_stack CLOB,
  9     created_on DATE,
 10     created_by VARCHAR2(100)
 11     )
 12     NOT FINAL
 13     ;
 14  /

Type created.

SQL>
SQL> CREATE TYPE dynsql_myError UNDER myError (
  2     sql_string CLOB
  3     )
  4     NOT FINAL
  5     ;
  6  /

Type created.

SQL>
SQL> CREATE TYPE employee_myError UNDER myError (
  2     employee_id INTEGER,
  3     rule_id INTEGER
  4     )
  5     ;
  6  /

Type created.

SQL>
SQL>
SQL> drop type employee_myError;

Type dropped.

SQL>
SQL> drop type dynsql_myError;

Type dropped.

SQL>
SQL> drop type myError;

Type dropped.

SQL>
SQL>
SQL>